Dataset statistics
| Number of variables | 42 |
|---|---|
| Number of observations | 122696 |
| Missing cells | 1036359 |
| Missing cells (%) | 20.1% |
| Total size in memory | 36.0 MiB |
| Average record size in memory | 308.0 B |
Variable types
| Text | 27 |
|---|---|
| Numeric | 9 |
| Boolean | 4 |
| Unsupported | 2 |
site_id has constant value "" | Constant |
promotions has constant value "" | Constant |
shipping_store_pick_up has constant value "" | Constant |
installments_rate has constant value "" | Constant |
installments_currency_id has constant value "" | Constant |
transactions_period has constant value "" | Constant |
accepts_mercadopago is highly imbalanced (57.8%) | Imbalance |
condition has 2512 (2.0%) missing values | Missing |
catalog_product_id has 72249 (58.9%) missing values | Missing |
price has 1233 (1.0%) missing values | Missing |
original_price has 94176 (76.8%) missing values | Missing |
official_store_id has 107401 (87.5%) missing values | Missing |
official_store_name has 107447 (87.6%) missing values | Missing |
shipping_logistic_type has 10083 (8.2%) missing values | Missing |
shipping_benefits has 122696 (100.0%) missing values | Missing |
shipping_promise has 122696 (100.0%) missing values | Missing |
installments_quantity has 26198 (21.4%) missing values | Missing |
installments_amount has 26198 (21.4%) missing values | Missing |
installments_rate has 26198 (21.4%) missing values | Missing |
installments_currency_id has 26198 (21.4%) missing values | Missing |
brand_value_name has 19767 (16.1%) missing values | Missing |
location has 112185 (91.4%) missing values | Missing |
seller_contact has 112185 (91.4%) missing values | Missing |
level_id has 10807 (8.8%) missing values | Missing |
power_seller_status has 36130 (29.4%) missing values | Missing |
price is highly skewed (γ1 = 21.66247958) | Skewed |
original_price is highly skewed (γ1 = 36.80519655) | Skewed |
available_quantity is highly skewed (γ1 = 34.47525357) | Skewed |
installments_amount is highly skewed (γ1 = 26.52925197) | Skewed |
shipping_benefits is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
shipping_promise is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
installments_rate has 96498 (78.6%) zeros | Zeros |
transactions_total has 9904 (8.1%) zeros | Zeros |
Reproduction
| Analysis started | 2024-02-26 20:14:50.842854 |
|---|---|
| Analysis finished | 2024-02-26 20:15:02.738667 |
| Duration | 11.9 seconds |
| Software version | ydata-profiling vv4.6.4 |
| Download configuration | config.json |
id
Text
| Distinct | 115879 |
|---|---|
| Distinct (%) | 94.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 958.7 KiB |
Length
| Max length | 13 |
|---|---|
| Median length | 13 |
| Mean length | 12.64945067 |
| Min length | 12 |
Characters and Unicode
| Total characters | 1552037 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 109072 ? |
|---|---|
| Unique (%) | 88.9% |
Sample
| 1st row | MCO1324022622 |
|---|---|
| 2nd row | MCO1271613775 |
| 3rd row | MCO1037658202 |
| 4th row | MCO1303242171 |
| 5th row | MCO889658125 |
| Value | Count | Frequency (%) |
| mco1228493631 | 3 | < 0.1% |
| mco1620188094 | 3 | < 0.1% |
| mco1149899347 | 3 | < 0.1% |
| mco1326134609 | 3 | < 0.1% |
| mco2213421240 | 3 | < 0.1% |
| mco1092024925 | 3 | < 0.1% |
| mco1303888682 | 3 | < 0.1% |
| mco2200882108 | 3 | < 0.1% |
| mco1347456295 | 3 | < 0.1% |
| mco1321892971 | 3 | < 0.1% |
| Other values (115869) | 122666 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 171673 | |
| 2 | 126265 | |
| 3 | 126071 | |
| M | 122696 | 7.9% |
| C | 122696 | 7.9% |
| O | 122696 | 7.9% |
| 8 | 114098 | 7.4% |
| 5 | 113389 | 7.3% |
| 9 | 111395 | 7.2% |
| 6 | 109379 | 7.0% |
| Other values (3) | 311679 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1183949 | |
| Uppercase Letter | 368088 | 23.7% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 171673 | |
| 2 | 126265 | |
| 3 | 126071 | |
| 8 | 114098 | |
| 5 | 113389 | |
| 9 | 111395 | |
| 6 | 109379 | |
| 0 | 107726 | |
| 4 | 102836 | |
| 7 | 101117 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 122696 | |
| C | 122696 | |
| O | 122696 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1183949 | |
| Latin | 368088 | 23.7% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 171673 | |
| 2 | 126265 | |
| 3 | 126071 | |
| 8 | 114098 | |
| 5 | 113389 | |
| 9 | 111395 | |
| 6 | 109379 | |
| 0 | 107726 | |
| 4 | 102836 | |
| 7 | 101117 |
Latin
| Value | Count | Frequency (%) |
| M | 122696 | |
| C | 122696 | |
| O | 122696 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1552037 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 171673 | |
| 2 | 126265 | |
| 3 | 126071 | |
| M | 122696 | 7.9% |
| C | 122696 | 7.9% |
| O | 122696 | 7.9% |
| 8 | 114098 | 7.4% |
| 5 | 113389 | 7.3% |
| 9 | 111395 | 7.2% |
| 6 | 109379 | 7.0% |
| Other values (3) | 311679 |
title
Text
| Distinct | 110242 |
|---|---|
| Distinct (%) | 89.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 958.7 KiB |
Length
| Max length | 200 |
|---|---|
| Median length | 190 |
| Mean length | 52.32736194 |
| Min length | 1 |
Characters and Unicode
| Total characters | 6420358 |
|---|---|
| Distinct characters | 148 |
| Distinct categories | 17 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 99735 ? |
|---|---|
| Unique (%) | 81.3% |
Sample
| 1st row | Pila Recargables Aa X2 Energizer 2000 Mah |
|---|---|
| 2nd row | Pila Energizer Recharge Universal Aaa X 4und |
| 3rd row | Audífonos In-ear Inalámbricos Bluetooth F9-5 Negro |
| 4th row | Televisor Samsung Cu7000 Crystal Uhd 55 pulgadas 2023 |
| 5th row | Parlante Jbl Bluetooth Charge 5 Color Black 110v/220v |
| Value | Count | Frequency (%) |
| de | 43605 | 4.2% |
| 28883 | 2.8% | |
| para | 18987 | 1.8% |
| en | 10973 | 1.1% |
| color | 10960 | 1.1% |
| a | 10517 | 1.0% |
| con | 8777 | 0.8% |
| y | 8540 | 0.8% |
| x | 7738 | 0.7% |
| negro | 6767 | 0.7% |
| Other values (75967) | 878287 |
Most occurring characters
| Value | Count | Frequency (%) |
| 937588 | 14.6% | |
| a | 564591 | 8.8% |
| o | 449905 | 7.0% |
| e | 433121 | 6.7% |
| r | 363645 | 5.7% |
| i | 321977 | 5.0% |
| l | 268129 | 4.2% |
| n | 254151 | 4.0% |
| t | 236124 | 3.7% |
| s | 217372 | 3.4% |
| Other values (138) | 2373755 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 4150392 | |
| Space Separator | 938281 | 14.6% |
| Uppercase Letter | 883915 | 13.8% |
| Decimal Number | 338287 | 5.3% |
| Other Punctuation | 53056 | 0.8% |
| Dash Punctuation | 30813 | 0.5% |
| Math Symbol | 9649 | 0.2% |
| Currency Symbol | 7384 | 0.1% |
| Open Punctuation | 3779 | 0.1% |
| Close Punctuation | 3531 | 0.1% |
| Other values (7) | 1271 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 564591 | |
| o | 449905 | |
| e | 433121 | |
| r | 363645 | |
| i | 321977 | 7.8% |
| l | 268129 | 6.5% |
| n | 254151 | 6.1% |
| t | 236124 | 5.7% |
| s | 217372 | 5.2% |
| c | 151743 | 3.7% |
| Other values (41) | 889634 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 103822 | 11.7% |
| P | 91103 | 10.3% |
| D | 76772 | 8.7% |
| M | 60008 | 6.8% |
| A | 59994 | 6.8% |
| S | 53269 | 6.0% |
| E | 50104 | 5.7% |
| B | 44934 | 5.1% |
| T | 40091 | 4.5% |
| L | 39485 | 4.5% |
| Other values (27) | 264333 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 18833 | |
| . | 16097 | |
| / | 10380 | |
| : | 1674 | 3.2% |
| ' | 1400 | 2.6% |
| % | 1153 | 2.2% |
| ! | 1036 | 2.0% |
| & | 853 | 1.6% |
| * | 623 | 1.2% |
| # | 487 | 0.9% |
| Other values (7) | 520 | 1.0% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 82790 | |
| 1 | 60362 | |
| 2 | 50328 | |
| 5 | 32435 | 9.6% |
| 3 | 26952 | 8.0% |
| 4 | 23968 | 7.1% |
| 6 | 19231 | 5.7% |
| 8 | 15947 | 4.7% |
| 7 | 13355 | 3.9% |
| 9 | 12919 | 3.8% |
Math Symbol
| Value | Count | Frequency (%) |
| + | 9034 | |
| | | 516 | 5.3% |
| × | 39 | 0.4% |
| = | 35 | 0.4% |
| ~ | 16 | 0.2% |
| ± | 8 | 0.1% |
| ÷ | 1 | < 0.1% |
Other Number
| Value | Count | Frequency (%) |
| ³ | 31 | |
| ½ | 22 | |
| ² | 20 | |
| ¼ | 11 | 13.1% |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 3532 | |
| [ | 243 | 6.4% |
| { | 4 | 0.1% |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 3305 | |
| ] | 221 | 6.3% |
| } | 5 | 0.1% |
Other Symbol
| Value | Count | Frequency (%) |
| ® | 448 | |
| ° | 306 | |
| © | 8 | 1.0% |
Modifier Symbol
| Value | Count | Frequency (%) |
| ´ | 219 | |
| ¨ | 9 | 3.8% |
| ` | 7 | 3.0% |
Space Separator
| Value | Count | Frequency (%) |
| 937588 | ||
| 693 | 0.1% |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 7383 | |
| £ | 1 | < 0.1% |
Other Letter
| Value | Count | Frequency (%) |
| ª | 76 | |
| º | 61 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 30813 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 45 |
Final Punctuation
| Value | Count | Frequency (%) |
| » | 5 |
Format
| Value | Count | Frequency (%) |
| | 3 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 5034443 | |
| Common | 1385915 | 21.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 564591 | 11.2% |
| o | 449905 | 8.9% |
| e | 433121 | 8.6% |
| r | 363645 | 7.2% |
| i | 321977 | 6.4% |
| l | 268129 | 5.3% |
| n | 254151 | 5.0% |
| t | 236124 | 4.7% |
| s | 217372 | 4.3% |
| c | 151743 | 3.0% |
| Other values (79) | 1773685 |
Common
| Value | Count | Frequency (%) |
| 937588 | ||
| 0 | 82790 | 6.0% |
| 1 | 60362 | 4.4% |
| 2 | 50328 | 3.6% |
| 5 | 32435 | 2.3% |
| - | 30813 | 2.2% |
| 3 | 26952 | 1.9% |
| 4 | 23968 | 1.7% |
| 6 | 19231 | 1.4% |
| , | 18833 | 1.4% |
| Other values (49) | 102615 | 7.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6360289 | |
| None | 60069 | 0.9% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 937588 | ||
| a | 564591 | 8.9% |
| o | 449905 | 7.1% |
| e | 433121 | 6.8% |
| r | 363645 | 5.7% |
| i | 321977 | 5.1% |
| l | 268129 | 4.2% |
| n | 254151 | 4.0% |
| t | 236124 | 3.7% |
| s | 217372 | 3.4% |
| Other values (81) | 2313686 |
None
| Value | Count | Frequency (%) |
| ó | 13906 | |
| á | 12895 | |
| ñ | 11288 | |
| í | 9745 | |
| é | 6775 | |
| ú | 1627 | 2.7% |
| 693 | 1.2% | |
| Á | 639 | 1.1% |
| ® | 448 | 0.7% |
| ° | 306 | 0.5% |
| Other values (47) | 1747 | 2.9% |
condition
Text
MISSING 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2512 |
| Missing (%) | 2.0% |
| Memory size | 958.7 KiB |
Length
| Max length | 13 |
|---|---|
| Median length | 3 |
| Mean length | 3.085468948 |
| Min length | 3 |
Characters and Unicode
| Total characters | 370824 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | new |
|---|---|
| 2nd row | new |
| 3rd row | new |
| 4th row | new |
| 5th row | new |
| Value | Count | Frequency (%) |
| new | 110398 | |
| used | 9732 | 8.1% |
| not_specified | 54 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 120238 | |
| n | 110452 | |
| w | 110398 | |
| s | 9786 | 2.6% |
| d | 9786 | 2.6% |
| u | 9732 | 2.6% |
| i | 108 | < 0.1% |
| o | 54 | < 0.1% |
| t | 54 | < 0.1% |
| _ | 54 | < 0.1% |
| Other values (3) | 162 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 370770 | |
| Connector Punctuation | 54 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 120238 | |
| n | 110452 | |
| w | 110398 | |
| s | 9786 | 2.6% |
| d | 9786 | 2.6% |
| u | 9732 | 2.6% |
| i | 108 | < 0.1% |
| o | 54 | < 0.1% |
| t | 54 | < 0.1% |
| p | 54 | < 0.1% |
| Other values (2) | 108 | < 0.1% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 54 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 370770 | |
| Common | 54 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 120238 | |
| n | 110452 | |
| w | 110398 | |
| s | 9786 | 2.6% |
| d | 9786 | 2.6% |
| u | 9732 | 2.6% |
| i | 108 | < 0.1% |
| o | 54 | < 0.1% |
| t | 54 | < 0.1% |
| p | 54 | < 0.1% |
| Other values (2) | 108 | < 0.1% |
Common
| Value | Count | Frequency (%) |
| _ | 54 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 370824 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 120238 | |
| n | 110452 | |
| w | 110398 | |
| s | 9786 | 2.6% |
| d | 9786 | 2.6% |
| u | 9732 | 2.6% |
| i | 108 | < 0.1% |
| o | 54 | < 0.1% |
| t | 54 | < 0.1% |
| _ | 54 | < 0.1% |
| Other values (3) | 162 | < 0.1% |
MISSING 
| Distinct | 41325 |
|---|---|
| Distinct (%) | 81.9% |
| Missing | 72249 |
| Missing (%) | 58.9% |
| Memory size | 958.7 KiB |
Length
| Max length | 13 |
|---|---|
| Median length | 11 |
| Mean length | 10.96986937 |
| Min length | 9 |
Characters and Unicode
| Total characters | 553397 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 34621 ? |
|---|---|
| Unique (%) | 68.6% |
Sample
| 1st row | MCO21850181 |
|---|---|
| 2nd row | MCO22015422 |
| 3rd row | MCO16224063 |
| 4th row | MCO23541767 |
| 5th row | MCO17949052 |
| Value | Count | Frequency (%) |
| mco18951365 | 20 | < 0.1% |
| mco6107994 | 20 | < 0.1% |
| mco16268158 | 17 | < 0.1% |
| mco19681518 | 17 | < 0.1% |
| mco21777210 | 16 | < 0.1% |
| mco22238606 | 16 | < 0.1% |
| mco8755482 | 15 | < 0.1% |
| mco6454377 | 15 | < 0.1% |
| mco18706965 | 15 | < 0.1% |
| mco27216699 | 15 | < 0.1% |
| Other values (41315) | 50281 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 68856 | |
| M | 50447 | |
| C | 50447 | |
| O | 50447 | |
| 1 | 48312 | |
| 7 | 37908 | 6.9% |
| 9 | 36459 | 6.6% |
| 0 | 36256 | 6.6% |
| 5 | 36137 | 6.5% |
| 3 | 35531 | 6.4% |
| Other values (3) | 102597 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 402056 | |
| Uppercase Letter | 151341 | 27.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 68856 | |
| 1 | 48312 | |
| 7 | 37908 | |
| 9 | 36459 | |
| 0 | 36256 | |
| 5 | 36137 | |
| 3 | 35531 | |
| 4 | 34378 | |
| 8 | 34196 | |
| 6 | 34023 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 50447 | |
| C | 50447 | |
| O | 50447 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 402056 | |
| Latin | 151341 | 27.3% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 68856 | |
| 1 | 48312 | |
| 7 | 37908 | |
| 9 | 36459 | |
| 0 | 36256 | |
| 5 | 36137 | |
| 3 | 35531 | |
| 4 | 34378 | |
| 8 | 34196 | |
| 6 | 34023 |
Latin
| Value | Count | Frequency (%) |
| M | 50447 | |
| C | 50447 | |
| O | 50447 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 553397 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 68856 | |
| M | 50447 | |
| C | 50447 | |
| O | 50447 | |
| 1 | 48312 | |
| 7 | 37908 | 6.9% |
| 9 | 36459 | 6.6% |
| 0 | 36256 | 6.6% |
| 5 | 36137 | 6.5% |
| 3 | 35531 | 6.4% |
| Other values (3) | 102597 |
listing_type_id
Text
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 958.7 KiB |
Length
| Max length | 12 |
|---|---|
| Median length | 12 |
| Mean length | 10.64473169 |
| Min length | 4 |
Characters and Unicode
| Total characters | 1306066 |
|---|---|
| Distinct characters | 19 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | gold_special |
|---|---|
| 2nd row | gold_special |
| 3rd row | gold_special |
| 4th row | gold_pro |
| 5th row | gold_special |
| Value | Count | Frequency (%) |
| gold_special | 74864 | |
| gold_pro | 37315 | |
| gold_premium | 8359 | 6.8% |
| free | 1939 | 1.6% |
| gold | 100 | 0.1% |
| bronze | 82 | 0.1% |
| silver | 37 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 195539 | |
| o | 158035 | |
| g | 120638 | |
| d | 120638 | |
| _ | 120538 | |
| p | 120538 | |
| e | 87220 | |
| i | 83260 | |
| s | 74901 | 5.7% |
| c | 74864 | 5.7% |
| Other values (9) | 149895 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1185528 | |
| Connector Punctuation | 120538 | 9.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| l | 195539 | |
| o | 158035 | |
| g | 120638 | |
| d | 120638 | |
| p | 120538 | |
| e | 87220 | |
| i | 83260 | |
| s | 74901 | 6.3% |
| c | 74864 | 6.3% |
| a | 74864 | 6.3% |
| Other values (8) | 75031 | 6.3% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 120538 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1185528 | |
| Common | 120538 | 9.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| l | 195539 | |
| o | 158035 | |
| g | 120638 | |
| d | 120638 | |
| p | 120538 | |
| e | 87220 | |
| i | 83260 | |
| s | 74901 | 6.3% |
| c | 74864 | 6.3% |
| a | 74864 | 6.3% |
| Other values (8) | 75031 | 6.3% |
Common
| Value | Count | Frequency (%) |
| _ | 120538 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1306066 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| l | 195539 | |
| o | 158035 | |
| g | 120638 | |
| d | 120638 | |
| _ | 120538 | |
| p | 120538 | |
| e | 87220 | |
| i | 83260 | |
| s | 74901 | 5.7% |
| c | 74864 | 5.7% |
| Other values (9) | 149895 |
permalink
Text
| Distinct | 115270 |
|---|---|
| Distinct (%) | 93.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 958.7 KiB |
Length
| Max length | 361 |
|---|---|
| Median length | 320 |
| Mean length | 103.4472354 |
| Min length | 47 |
Characters and Unicode
| Total characters | 12692562 |
|---|---|
| Distinct characters | 45 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 108037 ? |
|---|---|
| Unique (%) | 88.1% |
Sample
| 1st row | https://www.mercadolibre.com.co/pila-recargables-aa-x2-energizer-2000-mah/p/MCO21850181 |
|---|---|
| 2nd row | https://www.mercadolibre.com.co/pila-energizer-recharge-universal-aaa-x-4und/p/MCO22015422 |
| 3rd row | https://www.mercadolibre.com.co/audifonos-in-ear-inalambricos-bluetooth-f9-5-negro/p/MCO16224063 |
| 4th row | https://www.mercadolibre.com.co/televisor-samsung-cu7000-crystal-uhd-55pulgadas-2023/p/MCO23541767 |
| 5th row | https://www.mercadolibre.com.co/parlante-jbl-bluetooth-charge-5-color-black-110v220v/p/MCO17949052 |
| Value | Count | Frequency (%) |
| https://www.mercadolibre.com.co/boya-by-v1-negro/p/mco23076703 | 5 | < 0.1% |
| https://www.mercadolibre.com.co/microfono-hyperx-blx-solocast-condensador-cardioide-color-negro/p/mco17481564 | 5 | < 0.1% |
| https://www.mercadolibre.com.co/microfono-hyperx-quadcast-condensador-bidireccional-color-negro/p/mco15160609 | 5 | < 0.1% |
| https://www.mercadolibre.com.co/audifonos-over-ear-logitech-g-series-g733-con-bluetooth-color-negro/p/mco16269735 | 4 | < 0.1% |
| https://www.mercadolibre.com.co/audifonos-gamer-inalambricos-lenovo-lp7-negro/p/mco18536671 | 4 | < 0.1% |
| https://www.mercadolibre.com.co/microfono-fifine-k669-condensador-cardioide-color-negro/p/mco17469532 | 4 | < 0.1% |
| https://www.mercadolibre.com.co/microfono-hyperx-blx-solocast-condensador-cardioide-color-blanco/p/mco19520938 | 4 | < 0.1% |
| https://www.mercadolibre.com.co/airpods-pro-2-generacion-11/p/mco19623394 | 4 | < 0.1% |
| https://www.mercadolibre.com.co/microfono-razer-seiren-seiren-mini-condensador-supercardioide-color-blanco-mercurio/p/mco16650278 | 4 | < 0.1% |
| https://www.mercadolibre.com.co/microfono-hyperx-quadcast-s-condensador-omnidireccional-color-black/p/mco16265275 | 4 | < 0.1% |
| Other values (115260) | 122653 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 1137801 | 9.0% |
| o | 934536 | 7.4% |
| a | 844255 | 6.7% |
| e | 745883 | 5.9% |
| r | 730832 | 5.8% |
| c | 706895 | 5.6% |
| t | 602805 | 4.7% |
| i | 554675 | 4.4% |
| l | 507016 | 4.0% |
| / | 443192 | 3.5% |
| Other values (35) | 5484672 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 8566920 | |
| Decimal Number | 1430345 | 11.3% |
| Dash Punctuation | 1137801 | 9.0% |
| Other Punctuation | 933976 | 7.4% |
| Uppercase Letter | 538376 | 4.2% |
| Connector Punctuation | 85144 | 0.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 934536 | |
| a | 844255 | 9.9% |
| e | 745883 | 8.7% |
| r | 730832 | 8.5% |
| c | 706895 | 8.3% |
| t | 602805 | 7.0% |
| i | 554675 | 6.5% |
| l | 507016 | 5.9% |
| m | 415876 | 4.9% |
| s | 399245 | 4.7% |
| Other values (16) | 2124902 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 202892 | |
| 2 | 186377 | |
| 0 | 179253 | |
| 5 | 141202 | |
| 3 | 134054 | |
| 6 | 121592 | |
| 8 | 121028 | |
| 4 | 119979 | |
| 9 | 116437 | |
| 7 | 107531 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 207840 | |
| C | 122696 | |
| O | 122696 | |
| J | 85144 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 443192 | |
| . | 368088 | |
| : | 122696 | 13.1% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1137801 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 85144 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 9105296 | |
| Common | 3587266 | 28.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 934536 | 10.3% |
| a | 844255 | 9.3% |
| e | 745883 | 8.2% |
| r | 730832 | 8.0% |
| c | 706895 | 7.8% |
| t | 602805 | 6.6% |
| i | 554675 | 6.1% |
| l | 507016 | 5.6% |
| m | 415876 | 4.6% |
| s | 399245 | 4.4% |
| Other values (20) | 2663278 |
Common
| Value | Count | Frequency (%) |
| - | 1137801 | |
| / | 443192 | 12.4% |
| . | 368088 | 10.3% |
| 1 | 202892 | 5.7% |
| 2 | 186377 | 5.2% |
| 0 | 179253 | 5.0% |
| 5 | 141202 | 3.9% |
| 3 | 134054 | 3.7% |
| : | 122696 | 3.4% |
| 6 | 121592 | 3.4% |
| Other values (5) | 550119 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 12692562 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| - | 1137801 | 9.0% |
| o | 934536 | 7.4% |
| a | 844255 | 6.7% |
| e | 745883 | 5.9% |
| r | 730832 | 5.8% |
| c | 706895 | 5.6% |
| t | 602805 | 4.7% |
| i | 554675 | 4.4% |
| l | 507016 | 4.0% |
| / | 443192 | 3.5% |
| Other values (35) | 5484672 |
buying_mode
Text
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 958.7 KiB |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 1226960 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | buy_it_now |
|---|---|
| 2nd row | buy_it_now |
| 3rd row | buy_it_now |
| 4th row | buy_it_now |
| 5th row | buy_it_now |
| Value | Count | Frequency (%) |
| buy_it_now | 112185 | |
| classified | 10511 | 8.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| _ | 224370 | |
| i | 133207 | |
| b | 112185 | |
| u | 112185 | |
| y | 112185 | |
| t | 112185 | |
| n | 112185 | |
| o | 112185 | |
| w | 112185 | |
| s | 21022 | 1.7% |
| Other values (6) | 63066 | 5.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1002590 | |
| Connector Punctuation | 224370 | 18.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 133207 | |
| b | 112185 | |
| u | 112185 | |
| y | 112185 | |
| t | 112185 | |
| n | 112185 | |
| o | 112185 | |
| w | 112185 | |
| s | 21022 | 2.1% |
| c | 10511 | 1.0% |
| Other values (5) | 52555 | 5.2% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 224370 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1002590 | |
| Common | 224370 | 18.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| i | 133207 | |
| b | 112185 | |
| u | 112185 | |
| y | 112185 | |
| t | 112185 | |
| n | 112185 | |
| o | 112185 | |
| w | 112185 | |
| s | 21022 | 2.1% |
| c | 10511 | 1.0% |
| Other values (5) | 52555 | 5.2% |
Common
| Value | Count | Frequency (%) |
| _ | 224370 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1226960 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| _ | 224370 | |
| i | 133207 | |
| b | 112185 | |
| u | 112185 | |
| y | 112185 | |
| t | 112185 | |
| n | 112185 | |
| o | 112185 | |
| w | 112185 | |
| s | 21022 | 1.7% |
| Other values (6) | 63066 | 5.1% |
site_id
Text
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 958.7 KiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 368088 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | MCO |
|---|---|
| 2nd row | MCO |
| 3rd row | MCO |
| 4th row | MCO |
| 5th row | MCO |
| Value | Count | Frequency (%) |
| mco | 122696 |
Most occurring characters
| Value | Count | Frequency (%) |
| M | 122696 | |
| C | 122696 | |
| O | 122696 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 368088 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 122696 | |
| C | 122696 | |
| O | 122696 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 368088 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| M | 122696 | |
| C | 122696 | |
| O | 122696 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 368088 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| M | 122696 | |
| C | 122696 | |
| O | 122696 |
category_id
Text
| Distinct | 3776 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 958.7 KiB |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 8.247391928 |
| Min length | 7 |
Characters and Unicode
| Total characters | 1011922 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 691 ? |
|---|---|
| Unique (%) | 0.6% |
Sample
| 1st row | MCO7279 |
|---|---|
| 2nd row | MCO7279 |
| 3rd row | MCO3697 |
| 4th row | MCO14903 |
| 5th row | MCO3691 |
| Value | Count | Frequency (%) |
| mco1196 | 3998 | 3.3% |
| mco1744 | 3686 | 3.0% |
| mco1176 | 3185 | 2.6% |
| mco8830 | 2063 | 1.7% |
| mco1442 | 1784 | 1.5% |
| mco9355 | 1404 | 1.1% |
| mco1474 | 1334 | 1.1% |
| mco435877 | 1222 | 1.0% |
| mco167011 | 1135 | 0.9% |
| mco9356 | 1132 | 0.9% |
| Other values (3766) | 101753 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 134797 | |
| M | 122696 | |
| C | 122696 | |
| O | 122696 | |
| 4 | 85844 | |
| 7 | 67316 | |
| 6 | 64418 | |
| 3 | 61718 | |
| 8 | 47187 | 4.7% |
| 9 | 45895 | 4.5% |
| Other values (3) | 136659 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 643834 | |
| Uppercase Letter | 368088 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 134797 | |
| 4 | 85844 | |
| 7 | 67316 | |
| 6 | 64418 | |
| 3 | 61718 | |
| 8 | 47187 | 7.3% |
| 9 | 45895 | 7.1% |
| 5 | 45801 | 7.1% |
| 0 | 45585 | 7.1% |
| 2 | 45273 | 7.0% |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 122696 | |
| C | 122696 | |
| O | 122696 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 643834 | |
| Latin | 368088 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 134797 | |
| 4 | 85844 | |
| 7 | 67316 | |
| 6 | 64418 | |
| 3 | 61718 | |
| 8 | 47187 | 7.3% |
| 9 | 45895 | 7.1% |
| 5 | 45801 | 7.1% |
| 0 | 45585 | 7.1% |
| 2 | 45273 | 7.0% |
Latin
| Value | Count | Frequency (%) |
| M | 122696 | |
| C | 122696 | |
| O | 122696 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1011922 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 134797 | |
| M | 122696 | |
| C | 122696 | |
| O | 122696 | |
| 4 | 85844 | |
| 7 | 67316 | |
| 6 | 64418 | |
| 3 | 61718 | |
| 8 | 47187 | 4.7% |
| 9 | 45895 | 4.5% |
| Other values (3) | 136659 |
domain_id
Text
| Distinct | 2746 |
|---|---|
| Distinct (%) | 2.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 958.7 KiB |
Length
| Max length | 58 |
|---|---|
| Median length | 47 |
| Mean length | 20.05476136 |
| Min length | 7 |
Characters and Unicode
| Total characters | 2460639 |
|---|---|
| Distinct characters | 30 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 409 ? |
|---|---|
| Unique (%) | 0.3% |
Sample
| 1st row | MCO-CELL_BATTERIES |
|---|---|
| 2nd row | MCO-CELL_BATTERIES |
| 3rd row | MCO-HEADPHONES |
| 4th row | MCO-TELEVISIONS |
| 5th row | MCO-SPEAKERS |
| Value | Count | Frequency (%) |
| mco-books | 3998 | 3.3% |
| mco-cars_and_vans | 3686 | 3.0% |
| mco-music_albums | 3185 | 2.6% |
| mco-headphones | 2152 | 1.8% |
| mco-supplements | 2127 | 1.7% |
| mco-cats_and_dogs_foods | 1887 | 1.5% |
| mco-wristwatches | 1784 | 1.5% |
| mco-coins | 1404 | 1.1% |
| mco-individual_apartments_for_sale | 1334 | 1.1% |
| mco-balloons | 1222 | 1.0% |
| Other values (2736) | 99917 |
Most occurring characters
| Value | Count | Frequency (%) |
| O | 239478 | 9.7% |
| C | 227628 | 9.3% |
| S | 216410 | 8.8% |
| E | 190702 | 7.8% |
| M | 177243 | 7.2% |
| A | 164940 | 6.7% |
| _ | 163317 | 6.6% |
| R | 127160 | 5.2% |
| - | 122696 | 5.0% |
| I | 115756 | 4.7% |
| Other values (20) | 715309 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 2174563 | |
| Connector Punctuation | 163317 | 6.6% |
| Dash Punctuation | 122696 | 5.0% |
| Decimal Number | 63 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 239478 | |
| C | 227628 | |
| S | 216410 | |
| E | 190702 | 8.8% |
| M | 177243 | 8.2% |
| A | 164940 | 7.6% |
| R | 127160 | 5.8% |
| I | 115756 | 5.3% |
| T | 111595 | 5.1% |
| N | 102161 | 4.7% |
| Other values (16) | 501490 |
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 60 | |
| 2 | 3 | 4.8% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 163317 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 122696 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2174563 | |
| Common | 286076 | 11.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| O | 239478 | |
| C | 227628 | |
| S | 216410 | |
| E | 190702 | 8.8% |
| M | 177243 | 8.2% |
| A | 164940 | 7.6% |
| R | 127160 | 5.8% |
| I | 115756 | 5.3% |
| T | 111595 | 5.1% |
| N | 102161 | 4.7% |
| Other values (16) | 501490 |
Common
| Value | Count | Frequency (%) |
| _ | 163317 | |
| - | 122696 | |
| 3 | 60 | < 0.1% |
| 2 | 3 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2460639 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| O | 239478 | 9.7% |
| C | 227628 | 9.3% |
| S | 216410 | 8.8% |
| E | 190702 | 7.8% |
| M | 177243 | 7.2% |
| A | 164940 | 6.7% |
| _ | 163317 | 6.6% |
| R | 127160 | 5.2% |
| - | 122696 | 5.0% |
| I | 115756 | 4.7% |
| Other values (20) | 715309 |
price
Real number (ℝ)
MISSING  SKEWED 
| Distinct | 27616 |
|---|---|
| Distinct (%) | 22.7% |
| Missing | 1233 |
| Missing (%) | 1.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 22944222.68 |
| Minimum | 1400 |
|---|---|
| Maximum | 9999999999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 958.7 KiB |
Quantile statistics
| Minimum | 1400 |
|---|---|
| 5-th percentile | 11500 |
| Q1 | 32900 |
| median | 81500 |
| Q3 | 238836 |
| 95-th percentile | 41000000 |
| Maximum | 9999999999 |
| Range | 9999998599 |
| Interquartile range (IQR) | 205936 |
Descriptive statistics
| Standard deviation | 213317768.4 |
|---|---|
| Coefficient of variation (CV) | 9.297232312 |
| Kurtosis | 662.9662464 |
| Mean | 22944222.68 |
| Median Absolute Deviation (MAD) | 60500 |
| Skewness | 21.66247958 |
| Sum | 2.786874119 × 1012 |
| Variance | 4.550447034 × 1016 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 90000 | 986 | 0.8% |
| 39900 | 706 | 0.6% |
| 19900 | 676 | 0.6% |
| 29900 | 673 | 0.5% |
| 60000 | 614 | 0.5% |
| 70000 | 610 | 0.5% |
| 49900 | 609 | 0.5% |
| 50000 | 599 | 0.5% |
| 59900 | 543 | 0.4% |
| 35000 | 531 | 0.4% |
| Other values (27606) | 114916 | |
| (Missing) | 1233 | 1.0% |
| Value | Count | Frequency (%) |
| 1400 | 5 | < 0.1% |
| 1500 | 2 | < 0.1% |
| 2000 | 7 | < 0.1% |
| 2500 | 3 | < 0.1% |
| 2900 | 52 |
| Value | Count | Frequency (%) |
| 9999999999 | 5 | |
| 9999000000 | 1 | < 0.1% |
| 9350000000 | 1 | < 0.1% |
| 9000000000 | 1 | < 0.1% |
| 8700000000 | 1 | < 0.1% |
original_price
Real number (ℝ)
MISSING  SKEWED 
| Distinct | 7624 |
|---|---|
| Distinct (%) | 26.7% |
| Missing | 94176 |
| Missing (%) | 76.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 472822.7972 |
| Minimum | 3145 |
|---|---|
| Maximum | 319900000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 958.7 KiB |
Quantile statistics
| Minimum | 3145 |
|---|---|
| 5-th percentile | 14900 |
| Q1 | 39512 |
| median | 98889.5 |
| Q3 | 259900 |
| 95-th percentile | 1599900 |
| Maximum | 319900000 |
| Range | 319896855 |
| Interquartile range (IQR) | 220388 |
Descriptive statistics
| Standard deviation | 4351824.302 |
|---|---|
| Coefficient of variation (CV) | 9.203922331 |
| Kurtosis | 1722.60002 |
| Mean | 472822.7972 |
| Median Absolute Deviation (MAD) | 71890.5 |
| Skewness | 36.80519655 |
| Sum | 1.348490618 × 1010 |
| Variance | 1.893837475 × 1013 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 29900 | 250 | 0.2% |
| 49900 | 242 | 0.2% |
| 59900 | 232 | 0.2% |
| 89900 | 226 | 0.2% |
| 39900 | 224 | 0.2% |
| 99900 | 222 | 0.2% |
| 69900 | 222 | 0.2% |
| 19900 | 210 | 0.2% |
| 79900 | 184 | 0.1% |
| 199900 | 180 | 0.1% |
| Other values (7614) | 26328 | 21.5% |
| (Missing) | 94176 |
| Value | Count | Frequency (%) |
| 3145 | 2 | |
| 3200 | 1 | |
| 3225 | 1 | |
| 3239 | 1 | |
| 3500 | 1 |
| Value | Count | Frequency (%) |
| 319900000 | 1 | < 0.1% |
| 178990000 | 1 | < 0.1% |
| 144990000 | 6 | |
| 144900000 | 1 | < 0.1% |
| 142900000 | 1 | < 0.1% |
available_quantity
Real number (ℝ)
SKEWED 
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 98.87530156 |
| Minimum | 1 |
|---|---|
| Maximum | 50000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 958.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 250 |
| Maximum | 50000 |
| Range | 49999 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1354.285834 |
|---|---|
| Coefficient of variation (CV) | 13.69690724 |
| Kurtosis | 1259.854134 |
| Mean | 98.87530156 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 34.47525357 |
| Sum | 12131604 |
| Variance | 1834090.119 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 95654 | |
| 50 | 11621 | 9.5% |
| 500 | 5435 | 4.4% |
| 250 | 3146 | 2.6% |
| 150 | 2636 | 2.1% |
| 100 | 2573 | 2.1% |
| 200 | 966 | 0.8% |
| 5000 | 581 | 0.5% |
| 50000 | 84 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 95654 | |
| 50 | 11621 | 9.5% |
| 100 | 2573 | 2.1% |
| 150 | 2636 | 2.1% |
| 200 | 966 | 0.8% |
| Value | Count | Frequency (%) |
| 50000 | 84 | 0.1% |
| 5000 | 581 | 0.5% |
| 500 | 5435 | |
| 250 | 3146 | |
| 200 | 966 | 0.8% |
official_store_id
Real number (ℝ)
MISSING 
| Distinct | 551 |
|---|---|
| Distinct (%) | 3.6% |
| Missing | 107401 |
| Missing (%) | 87.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4671.642563 |
| Minimum | 2 |
|---|---|
| Maximum | 65680 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 958.7 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 153 |
| Q1 | 608 |
| median | 1278 |
| Q3 | 1960 |
| 95-th percentile | 50047 |
| Maximum | 65680 |
| Range | 65678 |
| Interquartile range (IQR) | 1352 |
Descriptive statistics
| Standard deviation | 13242.48175 |
|---|---|
| Coefficient of variation (CV) | 2.834652174 |
| Kurtosis | 10.62878236 |
| Mean | 4671.642563 |
| Median Absolute Deviation (MAD) | 682 |
| Skewness | 3.529216064 |
| Sum | 71452773 |
| Variance | 175363322.8 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1117 | 550 | 0.4% |
| 1278 | 459 | 0.4% |
| 1961 | 398 | 0.3% |
| 2059 | 395 | 0.3% |
| 2068 | 372 | 0.3% |
| 1287 | 366 | 0.3% |
| 663 | 278 | 0.2% |
| 344 | 272 | 0.2% |
| 467 | 239 | 0.2% |
| 535 | 229 | 0.2% |
| Other values (541) | 11737 | 9.6% |
| (Missing) | 107401 |
| Value | Count | Frequency (%) |
| 2 | 42 | < 0.1% |
| 4 | 28 | < 0.1% |
| 11 | 95 | |
| 22 | 114 | |
| 23 | 10 | < 0.1% |
| Value | Count | Frequency (%) |
| 65680 | 10 | < 0.1% |
| 65522 | 6 | < 0.1% |
| 64348 | 2 | < 0.1% |
| 63262 | 4 | < 0.1% |
| 62882 | 46 |
MISSING 
| Distinct | 548 |
|---|---|
| Distinct (%) | 3.6% |
| Missing | 107447 |
| Missing (%) | 87.6% |
| Memory size | 958.7 KiB |
Length
| Max length | 30 |
|---|---|
| Median length | 26 |
| Mean length | 10.04341268 |
| Min length | 2 |
Characters and Unicode
| Total characters | 153152 |
|---|---|
| Distinct characters | 60 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 68 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | Energizer |
|---|---|
| 2nd row | Energizer |
| 3rd row | Samsung |
| 4th row | Challenger |
| 5th row | Sony |
| Value | Count | Frequency (%) |
| libreria | 842 | 3.8% |
| la | 759 | 3.4% |
| ferreteria | 586 | 2.6% |
| croydon | 550 | 2.5% |
| de | 489 | 2.2% |
| u | 459 | 2.0% |
| gm | 398 | 1.8% |
| comunicaciones | 398 | 1.8% |
| ipetplace | 395 | 1.8% |
| ebook | 372 | 1.7% |
| Other values (661) | 17173 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 13962 | 9.1% |
| a | 13094 | 8.5% |
| o | 12729 | 8.3% |
| r | 9990 | 6.5% |
| i | 8922 | 5.8% |
| 7304 | 4.8% | |
| l | 7064 | 4.6% |
| t | 6434 | 4.2% |
| s | 6265 | 4.1% |
| n | 6228 | 4.1% |
| Other values (50) | 61160 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 112640 | |
| Uppercase Letter | 32935 | 21.5% |
| Space Separator | 7304 | 4.8% |
| Decimal Number | 273 | 0.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 13962 | |
| a | 13094 | |
| o | 12729 | |
| r | 9990 | |
| i | 8922 | 7.9% |
| l | 7064 | 6.3% |
| t | 6434 | 5.7% |
| s | 6265 | 5.6% |
| n | 6228 | 5.5% |
| c | 5057 | 4.5% |
| Other values (16) | 22895 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 2741 | 8.3% |
| L | 2487 | 7.6% |
| C | 2470 | 7.5% |
| E | 2211 | 6.7% |
| A | 2188 | 6.6% |
| I | 1943 | 5.9% |
| B | 1852 | 5.6% |
| O | 1822 | 5.5% |
| T | 1821 | 5.5% |
| R | 1626 | 4.9% |
| Other values (16) | 11774 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 155 | |
| 1 | 75 | |
| 6 | 16 | 5.9% |
| 3 | 14 | 5.1% |
| 0 | 9 | 3.3% |
| 4 | 2 | 0.7% |
| 5 | 2 | 0.7% |
Space Separator
| Value | Count | Frequency (%) |
| 7304 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 145575 | |
| Common | 7577 | 4.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 13962 | 9.6% |
| a | 13094 | 9.0% |
| o | 12729 | 8.7% |
| r | 9990 | 6.9% |
| i | 8922 | 6.1% |
| l | 7064 | 4.9% |
| t | 6434 | 4.4% |
| s | 6265 | 4.3% |
| n | 6228 | 4.3% |
| c | 5057 | 3.5% |
| Other values (42) | 55830 |
Common
| Value | Count | Frequency (%) |
| 7304 | ||
| 2 | 155 | 2.0% |
| 1 | 75 | 1.0% |
| 6 | 16 | 0.2% |
| 3 | 14 | 0.2% |
| 0 | 9 | 0.1% |
| 4 | 2 | < 0.1% |
| 5 | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 153152 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 13962 | 9.1% |
| a | 13094 | 8.5% |
| o | 12729 | 8.3% |
| r | 9990 | 6.5% |
| i | 8922 | 5.8% |
| 7304 | 4.8% | |
| l | 7064 | 4.6% |
| t | 6434 | 4.2% |
| s | 6265 | 4.1% |
| n | 6228 | 4.1% |
| Other values (50) | 61160 |
accepts_mercadopago
Boolean
IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 119.9 KiB |
| True | |
|---|---|
| False | 10511 |
| Value | Count | Frequency (%) |
| True | 112185 | |
| False | 10511 | 8.6% |
stop_time
Text
| Distinct | 20682 |
|---|---|
| Distinct (%) | 16.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 958.7 KiB |
Length
| Max length | 24 |
|---|---|
| Median length | 24 |
| Mean length | 24 |
| Min length | 24 |
Characters and Unicode
| Total characters | 2944704 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 16457 ? |
|---|---|
| Unique (%) | 13.4% |
Sample
| 1st row | 2043-03-12T04:00:00.000Z |
|---|---|
| 2nd row | 2044-02-03T14:32:39.000Z |
| 3rd row | 2042-10-29T04:00:00.000Z |
| 4th row | 2043-06-01T04:00:00.000Z |
| 5th row | 2042-04-29T04:00:00.000Z |
| Value | Count | Frequency (%) |
| 2043-08-17t04:00:00.000z | 421 | 0.3% |
| 2043-10-19t04:00:00.000z | 364 | 0.3% |
| 2043-07-19t04:00:00.000z | 358 | 0.3% |
| 2043-08-19t04:00:00.000z | 335 | 0.3% |
| 2043-08-03t04:00:00.000z | 329 | 0.3% |
| 2043-09-13t04:00:00.000z | 323 | 0.3% |
| 2043-08-23t04:00:00.000z | 317 | 0.3% |
| 2043-10-26t04:00:00.000z | 317 | 0.3% |
| 2043-07-22t04:00:00.000z | 316 | 0.3% |
| 2043-07-28t04:00:00.000z | 309 | 0.3% |
| Other values (20672) | 119307 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1161086 | |
| 4 | 265346 | 9.0% |
| - | 245392 | 8.3% |
| : | 245392 | 8.3% |
| 2 | 243863 | 8.3% |
| 1 | 149662 | 5.1% |
| T | 122696 | 4.2% |
| . | 122696 | 4.2% |
| Z | 122696 | 4.2% |
| 3 | 108069 | 3.7% |
| Other values (5) | 157806 | 5.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2085832 | |
| Other Punctuation | 368088 | 12.5% |
| Dash Punctuation | 245392 | 8.3% |
| Uppercase Letter | 245392 | 8.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 1161086 | |
| 4 | 265346 | 12.7% |
| 2 | 243863 | 11.7% |
| 1 | 149662 | 7.2% |
| 3 | 108069 | 5.2% |
| 5 | 35816 | 1.7% |
| 8 | 31618 | 1.5% |
| 7 | 31523 | 1.5% |
| 9 | 31428 | 1.5% |
| 6 | 27421 | 1.3% |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 245392 | |
| . | 122696 |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 122696 | |
| Z | 122696 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 245392 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2699312 | |
| Latin | 245392 | 8.3% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 1161086 | |
| 4 | 265346 | 9.8% |
| - | 245392 | 9.1% |
| : | 245392 | 9.1% |
| 2 | 243863 | 9.0% |
| 1 | 149662 | 5.5% |
| . | 122696 | 4.5% |
| 3 | 108069 | 4.0% |
| 5 | 35816 | 1.3% |
| 8 | 31618 | 1.2% |
| Other values (3) | 90372 | 3.3% |
Latin
| Value | Count | Frequency (%) |
| T | 122696 | |
| Z | 122696 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2944704 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 1161086 | |
| 4 | 265346 | 9.0% |
| - | 245392 | 8.3% |
| : | 245392 | 8.3% |
| 2 | 243863 | 8.3% |
| 1 | 149662 | 5.1% |
| T | 122696 | 4.2% |
| . | 122696 | 4.2% |
| Z | 122696 | 4.2% |
| 3 | 108069 | 3.7% |
| Other values (5) | 157806 | 5.4% |
catalog_listing
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 119.9 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 85144 | |
| True | 37552 |
promotions
Text
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 958.7 KiB |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 245392 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | [] |
|---|---|
| 2nd row | [] |
| 3rd row | [] |
| 4th row | [] |
| 5th row | [] |
| Value | Count | Frequency (%) |
| 122696 |
Most occurring characters
| Value | Count | Frequency (%) |
| [ | 122696 | |
| ] | 122696 |
Most occurring categories
| Value | Count | Frequency (%) |
| Open Punctuation | 122696 | |
| Close Punctuation | 122696 |
Most frequent character per category
Open Punctuation
| Value | Count | Frequency (%) |
| [ | 122696 |
Close Punctuation
| Value | Count | Frequency (%) |
| ] | 122696 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 245392 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| [ | 122696 | |
| ] | 122696 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 245392 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| [ | 122696 | |
| ] | 122696 |
category
Text
| Distinct | 32 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 958.7 KiB |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 7.328413314 |
| Min length | 7 |
Characters and Unicode
| Total characters | 899167 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | MCO1000 |
|---|---|
| 2nd row | MCO1000 |
| 3rd row | MCO1000 |
| 4th row | MCO1000 |
| 5th row | MCO1000 |
| Value | Count | Frequency (%) |
| mco1367 | 4000 | 3.3% |
| mco118204 | 4000 | 3.3% |
| mco175794 | 4000 | 3.3% |
| mco1430 | 4000 | 3.3% |
| mco1403 | 4000 | 3.3% |
| mco1368 | 4000 | 3.3% |
| mco1276 | 4000 | 3.3% |
| mco1743 | 4000 | 3.3% |
| mco1168 | 4000 | 3.3% |
| mco1747 | 3999 | 3.3% |
| Other values (22) | 82697 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 142372 | |
| M | 122696 | |
| C | 122696 | |
| O | 122696 | |
| 4 | 67044 | |
| 0 | 58775 | |
| 7 | 51944 | 5.8% |
| 3 | 48598 | 5.4% |
| 8 | 35980 | 4.0% |
| 9 | 35963 | 4.0% |
| Other values (3) | 90403 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 531079 | |
| Uppercase Letter | 368088 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 142372 | |
| 4 | 67044 | |
| 0 | 58775 | |
| 7 | 51944 | 9.8% |
| 3 | 48598 | 9.2% |
| 8 | 35980 | 6.8% |
| 9 | 35963 | 6.8% |
| 2 | 31979 | 6.0% |
| 5 | 30446 | 5.7% |
| 6 | 27978 | 5.3% |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 122696 | |
| C | 122696 | |
| O | 122696 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 531079 | |
| Latin | 368088 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 142372 | |
| 4 | 67044 | |
| 0 | 58775 | |
| 7 | 51944 | 9.8% |
| 3 | 48598 | 9.2% |
| 8 | 35980 | 6.8% |
| 9 | 35963 | 6.8% |
| 2 | 31979 | 6.0% |
| 5 | 30446 | 5.7% |
| 6 | 27978 | 5.3% |
Latin
| Value | Count | Frequency (%) |
| M | 122696 | |
| C | 122696 | |
| O | 122696 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 899167 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 142372 | |
| M | 122696 | |
| C | 122696 | |
| O | 122696 | |
| 4 | 67044 | |
| 0 | 58775 | |
| 7 | 51944 | 5.8% |
| 3 | 48598 | 5.4% |
| 8 | 35980 | 4.0% |
| 9 | 35963 | 4.0% |
| Other values (3) | 90403 |
shipping_store_pick_up
Boolean
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 119.9 KiB |
| False |
|---|
| Value | Count | Frequency (%) |
| False | 122696 |
shipping_free_shipping
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 119.9 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 70956 | |
| True | 51740 |
MISSING 
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 10083 |
| Missing (%) | 8.2% |
| Memory size | 958.7 KiB |
Length
| Max length | 13 |
|---|---|
| Median length | 11 |
| Mean length | 11.45890794 |
| Min length | 6 |
Characters and Unicode
| Total characters | 1290422 |
|---|---|
| Distinct characters | 19 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | fulfillment |
|---|---|
| 2nd row | fulfillment |
| 3rd row | cross_docking |
| 4th row | drop_off |
| 5th row | xd_drop_off |
| Value | Count | Frequency (%) |
| xd_drop_off | 45610 | |
| cross_docking | 38286 | |
| fulfillment | 15210 | 13.5% |
| drop_off | 9413 | 8.4% |
| not_specified | 3389 | 3.0% |
| custom | 612 | 0.5% |
| default | 93 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 190619 | |
| f | 143948 | |
| d | 142401 | |
| _ | 142308 | |
| r | 93309 | 7.2% |
| c | 80573 | 6.2% |
| s | 80573 | 6.2% |
| i | 60274 | 4.7% |
| p | 58412 | 4.5% |
| n | 56885 | 4.4% |
| Other values (9) | 241120 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1148114 | |
| Connector Punctuation | 142308 | 11.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 190619 | |
| f | 143948 | |
| d | 142401 | |
| r | 93309 | |
| c | 80573 | |
| s | 80573 | |
| i | 60274 | 5.2% |
| p | 58412 | 5.1% |
| n | 56885 | 5.0% |
| l | 45723 | 4.0% |
| Other values (8) | 195397 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 142308 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1148114 | |
| Common | 142308 | 11.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 190619 | |
| f | 143948 | |
| d | 142401 | |
| r | 93309 | |
| c | 80573 | |
| s | 80573 | |
| i | 60274 | 5.2% |
| p | 58412 | 5.1% |
| n | 56885 | 5.0% |
| l | 45723 | 4.0% |
| Other values (8) | 195397 |
Common
| Value | Count | Frequency (%) |
| _ | 142308 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1290422 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 190619 | |
| f | 143948 | |
| d | 142401 | |
| _ | 142308 | |
| r | 93309 | 7.2% |
| c | 80573 | 6.2% |
| s | 80573 | 6.2% |
| i | 60274 | 4.7% |
| p | 58412 | 4.5% |
| n | 56885 | 4.4% |
| Other values (9) | 241120 |
shipping_mode
Text
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 958.7 KiB |
Length
| Max length | 13 |
|---|---|
| Median length | 3 |
| Mean length | 4.112962118 |
| Min length | 3 |
Characters and Unicode
| Total characters | 504644 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | me2 |
|---|---|
| 2nd row | me2 |
| 3rd row | me2 |
| 4th row | me2 |
| 5th row | me2 |
| Value | Count | Frequency (%) |
| me2 | 108519 | |
| not_specified | 13472 | 11.0% |
| custom | 612 | 0.5% |
| me1 | 93 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 135556 | |
| m | 109224 | |
| 2 | 108519 | |
| i | 26944 | 5.3% |
| o | 14084 | 2.8% |
| t | 14084 | 2.8% |
| s | 14084 | 2.8% |
| c | 14084 | 2.8% |
| n | 13472 | 2.7% |
| _ | 13472 | 2.7% |
| Other values (5) | 41121 | 8.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 382560 | |
| Decimal Number | 108612 | 21.5% |
| Connector Punctuation | 13472 | 2.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 135556 | |
| m | 109224 | |
| i | 26944 | 7.0% |
| o | 14084 | 3.7% |
| t | 14084 | 3.7% |
| s | 14084 | 3.7% |
| c | 14084 | 3.7% |
| n | 13472 | 3.5% |
| p | 13472 | 3.5% |
| f | 13472 | 3.5% |
| Other values (2) | 14084 | 3.7% |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 108519 | |
| 1 | 93 | 0.1% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 13472 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 382560 | |
| Common | 122084 | 24.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 135556 | |
| m | 109224 | |
| i | 26944 | 7.0% |
| o | 14084 | 3.7% |
| t | 14084 | 3.7% |
| s | 14084 | 3.7% |
| c | 14084 | 3.7% |
| n | 13472 | 3.5% |
| p | 13472 | 3.5% |
| f | 13472 | 3.5% |
| Other values (2) | 14084 | 3.7% |
Common
| Value | Count | Frequency (%) |
| 2 | 108519 | |
| _ | 13472 | 11.0% |
| 1 | 93 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 504644 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 135556 | |
| m | 109224 | |
| 2 | 108519 | |
| i | 26944 | 5.3% |
| o | 14084 | 2.8% |
| t | 14084 | 2.8% |
| s | 14084 | 2.8% |
| c | 14084 | 2.8% |
| n | 13472 | 2.7% |
| _ | 13472 | 2.7% |
| Other values (5) | 41121 | 8.1% |
shipping_tags
Text
| Distinct | 127 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 958.7 KiB |
Length
| Max length | 135 |
|---|---|
| Median length | 132 |
| Mean length | 24.11442101 |
| Min length | 2 |
Characters and Unicode
| Total characters | 2958743 |
|---|---|
| Distinct characters | 37 |
| Distinct categories | 9 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 24 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | ['fulfillment', 'self_service_out'] |
|---|---|
| 2nd row | ['fulfillment', 'self_service_in'] |
| 3rd row | ['self_service_in'] |
| 4th row | ['mandatory_free_shipping'] |
| 5th row | ['mandatory_free_shipping'] |
| Value | Count | Frequency (%) |
| self_service_in | 54449 | |
| mandatory_free_shipping | 46987 | |
| 29448 | ||
| fulfillment | 15210 | 9.4% |
| self_service_out | 7682 | 4.8% |
| mco-chg-threshold-jan-23 | 3497 | 2.2% |
| fs_threshold_mco_change_apr2021 | 1182 | 0.7% |
| fs_threshold_mco_change_jul2021 | 1065 | 0.7% |
| fbm_in_process | 816 | 0.5% |
| is_flammable | 761 | 0.5% |
| Other values (8) | 447 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 306128 | 10.3% |
| ' | 264192 | 8.9% |
| _ | 230700 | 7.8% |
| i | 228110 | 7.7% |
| s | 182391 | 6.2% |
| n | 170924 | 5.8% |
| r | 164001 | 5.5% |
| f | 143445 | 4.8% |
| [ | 122696 | 4.1% |
| ] | 122696 | 4.1% |
| Other values (27) | 1023460 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 2096446 | |
| Other Punctuation | 303040 | 10.2% |
| Connector Punctuation | 230700 | 7.8% |
| Open Punctuation | 122696 | 4.1% |
| Close Punctuation | 122696 | 4.1% |
| Space Separator | 38848 | 1.3% |
| Decimal Number | 16341 | 0.6% |
| Dash Punctuation | 13988 | 0.5% |
| Uppercase Letter | 13988 | 0.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 306128 | |
| i | 228110 | |
| s | 182391 | 8.7% |
| n | 170924 | 8.2% |
| r | 164001 | 7.8% |
| f | 143445 | 6.8% |
| l | 116697 | 5.6% |
| a | 103113 | 4.9% |
| p | 96229 | 4.6% |
| t | 75992 | 3.6% |
| Other values (12) | 509416 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 8320 | |
| 3 | 3497 | |
| 1 | 2277 | 13.9% |
| 0 | 2247 | 13.8% |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 3497 | |
| C | 3497 | |
| O | 3497 | |
| J | 3497 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 264192 | |
| , | 38848 | 12.8% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 230700 |
Open Punctuation
| Value | Count | Frequency (%) |
| [ | 122696 |
Close Punctuation
| Value | Count | Frequency (%) |
| ] | 122696 |
Space Separator
| Value | Count | Frequency (%) |
| 38848 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 13988 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2110434 | |
| Common | 848309 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 306128 | |
| i | 228110 | |
| s | 182391 | 8.6% |
| n | 170924 | 8.1% |
| r | 164001 | 7.8% |
| f | 143445 | 6.8% |
| l | 116697 | 5.5% |
| a | 103113 | 4.9% |
| p | 96229 | 4.6% |
| t | 75992 | 3.6% |
| Other values (16) | 523404 |
Common
| Value | Count | Frequency (%) |
| ' | 264192 | |
| _ | 230700 | |
| [ | 122696 | |
| ] | 122696 | |
| , | 38848 | 4.6% |
| 38848 | 4.6% | |
| - | 13988 | 1.6% |
| 2 | 8320 | 1.0% |
| 3 | 3497 | 0.4% |
| 1 | 2277 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2958743 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 306128 | 10.3% |
| ' | 264192 | 8.9% |
| _ | 230700 | 7.8% |
| i | 228110 | 7.7% |
| s | 182391 | 6.2% |
| n | 170924 | 5.8% |
| r | 164001 | 5.5% |
| f | 143445 | 4.8% |
| [ | 122696 | 4.1% |
| ] | 122696 | 4.1% |
| Other values (27) | 1023460 |
shipping_benefits
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 122696 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 958.7 KiB |
shipping_promise
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 122696 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 958.7 KiB |
seller_id
Real number (ℝ)
| Distinct | 15025 |
|---|---|
| Distinct (%) | 12.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 461498176.2 |
| Minimum | 17434 |
|---|---|
| Maximum | 1699297072 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 958.7 KiB |
Quantile statistics
| Minimum | 17434 |
|---|---|
| 5-th percentile | 39810996 |
| Q1 | 160820235 |
| median | 311862503 |
| Q3 | 637840655 |
| 95-th percentile | 1357115454 |
| Maximum | 1699297072 |
| Range | 1699279638 |
| Interquartile range (IQR) | 477020420 |
Descriptive statistics
| Standard deviation | 409887353.7 |
|---|---|
| Coefficient of variation (CV) | 0.8881667899 |
| Kurtosis | 0.6435667519 |
| Mean | 461498176.2 |
| Median Absolute Deviation (MAD) | 207974631.5 |
| Skewness | 1.219056842 |
| Sum | 5.662398023 × 1013 |
| Variance | 1.680076427 × 1017 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 181939816 | 1094 | 0.9% |
| 791273252 | 885 | 0.7% |
| 1194088518 | 848 | 0.7% |
| 394380898 | 662 | 0.5% |
| 91086457 | 605 | 0.5% |
| 313600420 | 551 | 0.4% |
| 573609394 | 490 | 0.4% |
| 178562922 | 473 | 0.4% |
| 279263455 | 459 | 0.4% |
| 438128163 | 426 | 0.3% |
| Other values (15015) | 116203 |
| Value | Count | Frequency (%) |
| 17434 | 24 | |
| 51545 | 1 | < 0.1% |
| 79421 | 1 | < 0.1% |
| 83777 | 1 | < 0.1% |
| 86705 | 25 |
| Value | Count | Frequency (%) |
| 1699297072 | 1 | |
| 1699214406 | 1 | |
| 1699209680 | 1 | |
| 1699183850 | 1 | |
| 1699177230 | 1 |
seller_nickname
Text
| Distinct | 15025 |
|---|---|
| Distinct (%) | 12.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 958.7 KiB |
Length
| Max length | 30 |
|---|---|
| Median length | 24 |
| Mean length | 15.16344461 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1860494 |
|---|---|
| Distinct characters | 50 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 8149 ? |
|---|---|
| Unique (%) | 6.6% |
Sample
| 1st row | OPERADOR TO |
|---|---|
| 2nd row | OPERADOR TO |
| 3rd row | JUAN20220131132107 |
| 4th row | SAMSUNG COLOMBIA |
| 5th row | EGP_TECNOLOGIA |
| Value | Count | Frequency (%) |
| sas | 3316 | 2.0% |
| colombia | 2146 | 1.3% |
| s.a.s | 1618 | 1.0% |
| store | 1476 | 0.9% |
| tienda | 1386 | 0.8% |
| discotienda | 1094 | 0.7% |
| hitmusical | 1094 | 0.7% |
| online | 916 | 0.6% |
| liberimportacinsasliberimp | 885 | 0.5% |
| gruporespaldoinmobiliariosa | 848 | 0.5% |
| Other values (15951) | 148725 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 179899 | 9.7% |
| O | 169352 | 9.1% |
| E | 152394 | 8.2% |
| I | 140471 | 7.6% |
| S | 122276 | 6.6% |
| R | 113704 | 6.1% |
| C | 100194 | 5.4% |
| L | 90424 | 4.9% |
| T | 88795 | 4.8% |
| N | 87960 | 4.7% |
| Other values (40) | 615025 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1653444 | |
| Decimal Number | 131175 | 7.1% |
| Space Separator | 40809 | 2.2% |
| Other Punctuation | 17637 | 0.9% |
| Connector Punctuation | 11980 | 0.6% |
| Dash Punctuation | 5449 | 0.3% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 179899 | |
| O | 169352 | |
| E | 152394 | 9.2% |
| I | 140471 | 8.5% |
| S | 122276 | 7.4% |
| R | 113704 | 6.9% |
| C | 100194 | 6.1% |
| L | 90424 | 5.5% |
| T | 88795 | 5.4% |
| N | 87960 | 5.3% |
| Other values (23) | 407975 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 27311 | |
| 0 | 21519 | |
| 1 | 19538 | |
| 3 | 12207 | |
| 4 | 9613 | 7.3% |
| 5 | 9362 | 7.1% |
| 9 | 8366 | 6.4% |
| 7 | 8009 | 6.1% |
| 6 | 7875 | 6.0% |
| 8 | 7375 | 5.6% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 17629 | |
| * | 6 | < 0.1% |
| : | 1 | < 0.1% |
| @ | 1 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 40809 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 11980 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 5449 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1653444 | |
| Common | 207050 | 11.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 179899 | |
| O | 169352 | |
| E | 152394 | 9.2% |
| I | 140471 | 8.5% |
| S | 122276 | 7.4% |
| R | 113704 | 6.9% |
| C | 100194 | 6.1% |
| L | 90424 | 5.5% |
| T | 88795 | 5.4% |
| N | 87960 | 5.3% |
| Other values (23) | 407975 |
Common
| Value | Count | Frequency (%) |
| 40809 | ||
| 2 | 27311 | |
| 0 | 21519 | |
| 1 | 19538 | |
| . | 17629 | |
| 3 | 12207 | 5.9% |
| _ | 11980 | 5.8% |
| 4 | 9613 | 4.6% |
| 5 | 9362 | 4.5% |
| 9 | 8366 | 4.0% |
| Other values (7) | 28716 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1858994 | |
| None | 1500 | 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 179899 | 9.7% |
| O | 169352 | 9.1% |
| E | 152394 | 8.2% |
| I | 140471 | 7.6% |
| S | 122276 | 6.6% |
| R | 113704 | 6.1% |
| C | 100194 | 5.4% |
| L | 90424 | 4.9% |
| T | 88795 | 4.8% |
| N | 87960 | 4.7% |
| Other values (33) | 613525 |
None
| Value | Count | Frequency (%) |
| Í | 461 | |
| Ñ | 282 | |
| Ó | 280 | |
| Á | 232 | |
| É | 189 | |
| Ú | 52 | 3.5% |
| Ü | 4 | 0.3% |
installments_quantity
Real number (ℝ)
MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 26198 |
| Missing (%) | 21.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28.22234658 |
| Minimum | 12 |
|---|---|
| Maximum | 36 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 958.7 KiB |
Quantile statistics
| Minimum | 12 |
|---|---|
| 5-th percentile | 12 |
| Q1 | 12 |
| median | 36 |
| Q3 | 36 |
| 95-th percentile | 36 |
| Maximum | 36 |
| Range | 24 |
| Interquartile range (IQR) | 24 |
Descriptive statistics
| Standard deviation | 11.23267986 |
|---|---|
| Coefficient of variation (CV) | 0.3980065879 |
| Kurtosis | -1.43480783 |
| Mean | 28.22234658 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -0.7518124156 |
| Sum | 2723400 |
| Variance | 126.1730969 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 36 | 65226 | |
| 12 | 31272 | |
| (Missing) | 26198 |
| Value | Count | Frequency (%) |
| 12 | 31272 | |
| 36 | 65226 |
| Value | Count | Frequency (%) |
| 36 | 65226 | |
| 12 | 31272 |
installments_amount
Real number (ℝ)
MISSING  SKEWED 
| Distinct | 25960 |
|---|---|
| Distinct (%) | 26.9% |
| Missing | 26198 |
| Missing (%) | 21.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13661.45928 |
| Minimum | 546.81 |
|---|---|
| Maximum | 4086158.33 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 958.7 KiB |
Quantile statistics
| Minimum | 546.81 |
|---|---|
| 5-th percentile | 732.86 |
| Q1 | 1815.1675 |
| median | 3747.22 |
| Q3 | 8886.11 |
| 95-th percentile | 48274.21 |
| Maximum | 4086158.33 |
| Range | 4085611.52 |
| Interquartile range (IQR) | 7070.9425 |
Descriptive statistics
| Standard deviation | 61214.09133 |
|---|---|
| Coefficient of variation (CV) | 4.48078716 |
| Kurtosis | 1100.19588 |
| Mean | 13661.45928 |
| Median Absolute Deviation (MAD) | 2466.66 |
| Skewness | 26.52925197 |
| Sum | 1318303497 |
| Variance | 3747164977 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2500 | 771 | 0.6% |
| 4166.67 | 474 | 0.4% |
| 1666.67 | 462 | 0.4% |
| 5000 | 442 | 0.4% |
| 1108.33 | 430 | 0.4% |
| 7500 | 409 | 0.3% |
| 5833.33 | 382 | 0.3% |
| 1386.11 | 375 | 0.3% |
| 2083.33 | 374 | 0.3% |
| 552.78 | 367 | 0.3% |
| Other values (25950) | 92012 | |
| (Missing) | 26198 | 21.4% |
| Value | Count | Frequency (%) |
| 546.81 | 1 | < 0.1% |
| 546.94 | 2 | < 0.1% |
| 547.19 | 2 | < 0.1% |
| 547.22 | 20 | |
| 547.42 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 4086158.33 | 1 | |
| 3583333.33 | 1 | |
| 3453241.67 | 1 | |
| 3333333.33 | 1 | |
| 2962575 | 1 |
installments_rate
Real number (ℝ)
CONSTANT  MISSING  ZEROS 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 26198 |
| Missing (%) | 21.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0 |
| Minimum | 0 |
|---|---|
| Maximum | 0 |
| Zeros | 96498 |
| Zeros (%) | 78.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 958.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 0 |
| Range | 0 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0 |
|---|---|
| Coefficient of variation (CV) | nan |
| Kurtosis | 0 |
| Mean | 0 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0 |
| Sum | 0 |
| Variance | 0 |
| Monotonicity | Increasing |
| Value | Count | Frequency (%) |
| 0 | 96498 | |
| (Missing) | 26198 | 21.4% |
| Value | Count | Frequency (%) |
| 0 | 96498 |
| Value | Count | Frequency (%) |
| 0 | 96498 |
CONSTANT  MISSING 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 26198 |
| Missing (%) | 21.4% |
| Memory size | 958.7 KiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 289494 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | COP |
|---|---|
| 2nd row | COP |
| 3rd row | COP |
| 4th row | COP |
| 5th row | COP |
| Value | Count | Frequency (%) |
| cop | 96498 |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 96498 | |
| O | 96498 | |
| P | 96498 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 289494 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 96498 | |
| O | 96498 | |
| P | 96498 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 289494 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| C | 96498 | |
| O | 96498 | |
| P | 96498 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 289494 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| C | 96498 | |
| O | 96498 | |
| P | 96498 |
brand_value_name
Text
MISSING 
| Distinct | 19762 |
|---|---|
| Distinct (%) | 19.2% |
| Missing | 19767 |
| Missing (%) | 16.1% |
| Memory size | 958.7 KiB |
Length
| Max length | 214 |
|---|---|
| Median length | 200 |
| Mean length | 8.57925366 |
| Min length | 1 |
Characters and Unicode
| Total characters | 883054 |
|---|---|
| Distinct characters | 125 |
| Distinct categories | 16 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 4 ? |
Unique
| Unique | 11330 ? |
|---|---|
| Unique (%) | 11.0% |
Sample
| 1st row | Energizer |
|---|---|
| 2nd row | Energizer |
| 3rd row | Shenzhen Yihaotong |
| 4th row | Samsung |
| 5th row | JBL |
| Value | Count | Frequency (%) |
| genérica | 10637 | 7.7% |
| truper | 1057 | 0.8% |
| de | 1044 | 0.8% |
| casio | 757 | 0.6% |
| 653 | 0.5% | |
| sony | 631 | 0.5% |
| samsung | 624 | 0.5% |
| nintendo | 601 | 0.4% |
| la | 566 | 0.4% |
| home | 535 | 0.4% |
| Other values (18028) | 120443 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 72037 | 8.2% |
| a | 71811 | 8.1% |
| i | 57889 | 6.6% |
| o | 54973 | 6.2% |
| r | 54836 | 6.2% |
| n | 49993 | 5.7% |
| 34765 | 3.9% | |
| l | 34331 | 3.9% |
| t | 32871 | 3.7% |
| c | 31133 | 3.5% |
| Other values (115) | 388415 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 629790 | |
| Uppercase Letter | 207288 | 23.5% |
| Space Separator | 34771 | 3.9% |
| Other Punctuation | 4105 | 0.5% |
| Decimal Number | 4085 | 0.5% |
| Dash Punctuation | 2143 | 0.2% |
| Math Symbol | 309 | < 0.1% |
| Connector Punctuation | 250 | < 0.1% |
| Modifier Symbol | 152 | < 0.1% |
| Final Punctuation | 50 | < 0.1% |
| Other values (6) | 111 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 72037 | |
| a | 71811 | |
| i | 57889 | |
| o | 54973 | 8.7% |
| r | 54836 | 8.7% |
| n | 49993 | 7.9% |
| l | 34331 | 5.5% |
| t | 32871 | 5.2% |
| c | 31133 | 4.9% |
| s | 30333 | 4.8% |
| Other values (37) | 139583 |
Uppercase Letter
| Value | Count | Frequency (%) |
| G | 17380 | 8.4% |
| S | 15595 | 7.5% |
| A | 14580 | 7.0% |
| C | 13196 | 6.4% |
| M | 12784 | 6.2% |
| E | 12226 | 5.9% |
| T | 12150 | 5.9% |
| P | 10561 | 5.1% |
| L | 9654 | 4.7% |
| O | 9647 | 4.7% |
| Other values (25) | 79515 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 1299 | |
| ' | 971 | |
| & | 841 | |
| , | 610 | |
| / | 151 | 3.7% |
| : | 92 | 2.2% |
| % | 64 | 1.6% |
| ! | 50 | 1.2% |
| * | 14 | 0.3% |
| # | 5 | 0.1% |
| Other values (3) | 8 | 0.2% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 1016 | |
| 1 | 697 | |
| 3 | 597 | |
| 2 | 513 | |
| 4 | 311 | 7.6% |
| 5 | 265 | 6.5% |
| 6 | 249 | 6.1% |
| 8 | 184 | 4.5% |
| 7 | 164 | 4.0% |
| 9 | 89 | 2.2% |
Math Symbol
| Value | Count | Frequency (%) |
| + | 307 | |
| ± | 1 | 0.3% |
| > | 1 | 0.3% |
Other Symbol
| Value | Count | Frequency (%) |
| ® | 12 | |
| ° | 4 | 22.2% |
| ™ | 2 | 11.1% |
Space Separator
| Value | Count | Frequency (%) |
| 34765 | ||
| 6 | < 0.1% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 2142 | |
| – | 1 | < 0.1% |
Modifier Symbol
| Value | Count | Frequency (%) |
| ´ | 150 | |
| ` | 2 | 1.3% |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 43 | |
| [ | 1 | 2.3% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 250 |
Final Punctuation
| Value | Count | Frequency (%) |
| ’ | 50 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 43 |
Other Letter
| Value | Count | Frequency (%) |
| º | 4 |
Other Number
| Value | Count | Frequency (%) |
| ² | 1 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 837082 | |
| Common | 45972 | 5.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 72037 | 8.6% |
| a | 71811 | 8.6% |
| i | 57889 | 6.9% |
| o | 54973 | 6.6% |
| r | 54836 | 6.6% |
| n | 49993 | 6.0% |
| l | 34331 | 4.1% |
| t | 32871 | 3.9% |
| c | 31133 | 3.7% |
| s | 30333 | 3.6% |
| Other values (73) | 346875 |
Common
| Value | Count | Frequency (%) |
| 34765 | ||
| - | 2142 | 4.7% |
| . | 1299 | 2.8% |
| 0 | 1016 | 2.2% |
| ' | 971 | 2.1% |
| & | 841 | 1.8% |
| 1 | 697 | 1.5% |
| , | 610 | 1.3% |
| 3 | 597 | 1.3% |
| 2 | 513 | 1.1% |
| Other values (32) | 2521 | 5.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 868893 | |
| None | 14108 | 1.6% |
| Punctuation | 51 | < 0.1% |
| Letterlike Symbols | 2 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 72037 | 8.3% |
| a | 71811 | 8.3% |
| i | 57889 | 6.7% |
| o | 54973 | 6.3% |
| r | 54836 | 6.3% |
| n | 49993 | 5.8% |
| 34765 | 4.0% | |
| l | 34331 | 4.0% |
| t | 32871 | 3.8% |
| c | 31133 | 3.6% |
| Other values (75) | 374254 |
None
| Value | Count | Frequency (%) |
| é | 11249 | |
| í | 704 | 5.0% |
| ó | 682 | 4.8% |
| ñ | 315 | 2.2% |
| á | 277 | 2.0% |
| ä | 214 | 1.5% |
| ú | 153 | 1.1% |
| ´ | 150 | 1.1% |
| Ñ | 77 | 0.5% |
| ü | 30 | 0.2% |
| Other values (27) | 257 | 1.8% |
Punctuation
| Value | Count | Frequency (%) |
| ’ | 50 | |
| – | 1 | 2.0% |
Letterlike Symbols
| Value | Count | Frequency (%) |
| ™ | 2 |
location
Text
MISSING 
| Distinct | 6566 |
|---|---|
| Distinct (%) | 62.5% |
| Missing | 112185 |
| Missing (%) | 91.4% |
| Memory size | 958.7 KiB |
Length
| Max length | 514 |
|---|---|
| Median length | 414 |
| Mean length | 338.5627438 |
| Min length | 234 |
Characters and Unicode
| Total characters | 3558633 |
|---|---|
| Distinct characters | 95 |
| Distinct categories | 13 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 3 ? |
Unique
| Unique | 5786 ? |
|---|---|
| Unique (%) | 55.0% |
Sample
| 1st row | {'address_line': 'Cl. 181a #7-28, Bogotá, Colombia', 'zip_code': '', 'subneighborhood': None, 'neighborhood': {'id': 'TUNPQlNBTjkyNDYy', 'name': 'San Antonio Norte'}, 'city': {'id': 'TUNPQ1VTQTY3MTQ1', 'name': 'Usaquén'}, 'state': {'id': 'TUNPUEJPR1gxMDljZA', 'name': 'Bogotá D.C.'}, 'country': {'id': 'CO', 'name': 'Colombia'}, 'latitude': 4.7583128, 'longitude': -74.0261957} |
|---|---|
| 2nd row | {'address_line': 'Calle 145a #13a-90, Bogotá, Colombia', 'zip_code': '', 'subneighborhood': None, 'neighborhood': {'id': 'TUNPQkNFRDEzNzQw', 'name': 'Cedritos'}, 'city': {'id': 'TUNPQ1VTQTY3MTQ1', 'name': 'Usaquén'}, 'state': {'id': 'TUNPUEJPR1gxMDljZA', 'name': 'Bogotá D.C.'}, 'country': {'id': 'CO', 'name': 'Colombia'}, 'latitude': 4.7268959, 'longitude': -74.0401792} |
| 3rd row | {'address_line': 'Cl. 175 #15-20, Bogotá, Colombia', 'zip_code': '', 'subneighborhood': None, 'neighborhood': {'id': 'TUNPQkxBNzE0ODc', 'name': 'La Alameda'}, 'city': {'id': 'TUNPQ1VTQTY3MTQ1', 'name': 'Usaquén'}, 'state': {'id': 'TUNPUEJPR1gxMDljZA', 'name': 'Bogotá D.C.'}, 'country': {'id': 'CO', 'name': 'Colombia'}, 'latitude': 4.7553061, 'longitude': -74.0373278} |
| 4th row | {'address_line': 'Transversal 5d, El Poblado, Medellín, Antioquia, Colombia', 'zip_code': '', 'subneighborhood': None, 'neighborhood': {'id': 'TUNPQkVMUDI3MDA0Ng', 'name': 'El Poblado'}, 'city': {'id': 'TUNPQ01FRGRjNjc4', 'name': 'Medellín'}, 'state': {'id': 'TUNPUEFOVGFiZWI3', 'name': 'Antioquia'}, 'country': {'id': 'CO', 'name': 'Colombia'}, 'latitude': 6.2058014, 'longitude': -75.5697919} |
| 5th row | {'address_line': 'Sur', 'zip_code': '', 'subneighborhood': None, 'neighborhood': {}, 'city': {'id': 'TUNPQ0NBTDYyZDA0', 'name': 'Cali'}, 'state': {'id': 'TUNPUFZBTGExNmNjNg', 'name': 'Valle Del Cauca'}, 'country': {'id': 'CO', 'name': 'Colombia'}, 'latitude': 3.3704066, 'longitude': -76.5053344} |
| Value | Count | Frequency (%) |
| name | 39420 | 11.7% |
| id | 39420 | 11.7% |
| 18884 | 5.6% | |
| colombia | 12736 | 3.8% |
| country | 10569 | 3.1% |
| city | 10512 | 3.1% |
| co | 10511 | 3.1% |
| state | 10511 | 3.1% |
| address_line | 10511 | 3.1% |
| neighborhood | 10511 | 3.1% |
| Other values (17446) | 163607 |
Most occurring characters
| Value | Count | Frequency (%) |
| ' | 542986 | 15.3% |
| 327103 | 9.2% | |
| : | 171632 | 4.8% |
| o | 157739 | 4.4% |
| e | 154582 | 4.3% |
| i | 148529 | 4.2% |
| a | 129429 | 3.6% |
| , | 127736 | 3.6% |
| n | 123396 | 3.5% |
| d | 122275 | 3.4% |
| Other values (85) | 1553226 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1527120 | |
| Other Punctuation | 874091 | |
| Uppercase Letter | 469105 | 13.2% |
| Space Separator | 327103 | 9.2% |
| Decimal Number | 222630 | 6.3% |
| Open Punctuation | 52644 | 1.5% |
| Close Punctuation | 52644 | 1.5% |
| Connector Punctuation | 21029 | 0.6% |
| Dash Punctuation | 12126 | 0.3% |
| Math Symbol | 133 | < 0.1% |
| Other values (3) | 8 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 157739 | 10.3% |
| e | 154582 | 10.1% |
| i | 148529 | 9.7% |
| a | 129429 | 8.5% |
| n | 123396 | 8.1% |
| d | 122275 | 8.0% |
| t | 89032 | 5.8% |
| l | 72362 | 4.7% |
| m | 59752 | 3.9% |
| r | 59366 | 3.9% |
| Other values (23) | 410658 |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 59860 | |
| U | 49232 | 10.5% |
| T | 48165 | 10.3% |
| C | 37860 | 8.1% |
| P | 37317 | 8.0% |
| Q | 29500 | 6.3% |
| M | 19243 | 4.1% |
| O | 19051 | 4.1% |
| D | 18873 | 4.0% |
| E | 16819 | 3.6% |
| Other values (19) | 133185 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 542986 | |
| : | 171632 | 19.6% |
| , | 127736 | 14.6% |
| . | 29346 | 3.4% |
| # | 2312 | 0.3% |
| / | 52 | < 0.1% |
| & | 20 | < 0.1% |
| · | 3 | < 0.1% |
| \ | 2 | < 0.1% |
| ¿ | 1 | < 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 32775 | |
| 4 | 28179 | |
| 7 | 25015 | |
| 0 | 23839 | |
| 5 | 23660 | |
| 3 | 22665 | |
| 6 | 19875 | |
| 2 | 18668 | |
| 8 | 14066 | |
| 9 | 13888 |
Open Punctuation
| Value | Count | Frequency (%) |
| { | 52555 | |
| ( | 89 | 0.2% |
Close Punctuation
| Value | Count | Frequency (%) |
| } | 52555 | |
| ) | 89 | 0.2% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 12122 | |
| – | 4 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 327103 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 21029 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 133 |
Other Symbol
| Value | Count | Frequency (%) |
| ° | 4 |
Other Letter
| Value | Count | Frequency (%) |
| ª | 3 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1996228 | |
| Common | 1562405 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 157739 | 7.9% |
| e | 154582 | 7.7% |
| i | 148529 | 7.4% |
| a | 129429 | 6.5% |
| n | 123396 | 6.2% |
| d | 122275 | 6.1% |
| t | 89032 | 4.5% |
| l | 72362 | 3.6% |
| N | 59860 | 3.0% |
| m | 59752 | 3.0% |
| Other values (53) | 879272 |
Common
| Value | Count | Frequency (%) |
| ' | 542986 | |
| 327103 | ||
| : | 171632 | 11.0% |
| , | 127736 | 8.2% |
| { | 52555 | 3.4% |
| } | 52555 | 3.4% |
| 1 | 32775 | 2.1% |
| . | 29346 | 1.9% |
| 4 | 28179 | 1.8% |
| 7 | 25015 | 1.6% |
| Other values (22) | 172523 | 11.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3546508 | |
| None | 12121 | 0.3% |
| Punctuation | 4 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| ' | 542986 | 15.3% |
| 327103 | 9.2% | |
| : | 171632 | 4.8% |
| o | 157739 | 4.4% |
| e | 154582 | 4.4% |
| i | 148529 | 4.2% |
| a | 129429 | 3.6% |
| , | 127736 | 3.6% |
| n | 123396 | 3.5% |
| d | 122275 | 3.4% |
| Other values (70) | 1541101 |
None
| Value | Count | Frequency (%) |
| á | 6393 | |
| í | 2733 | |
| é | 1662 | 13.7% |
| ó | 820 | 6.8% |
| ñ | 339 | 2.8% |
| ú | 120 | 1.0% |
| ü | 26 | 0.2% |
| Á | 13 | 0.1% |
| ° | 4 | < 0.1% |
| Ñ | 3 | < 0.1% |
| Other values (4) | 8 | 0.1% |
Punctuation
| Value | Count | Frequency (%) |
| – | 4 |
seller_contact
Text
MISSING 
| Distinct | 3490 |
|---|---|
| Distinct (%) | 33.2% |
| Missing | 112185 |
| Missing (%) | 91.4% |
| Memory size | 958.7 KiB |
Length
| Max length | 252 |
|---|---|
| Median length | 241 |
| Mean length | 133.2624869 |
| Min length | 123 |
Characters and Unicode
| Total characters | 1400722 |
|---|---|
| Distinct characters | 92 |
| Distinct categories | 10 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 3145 ? |
|---|---|
| Unique (%) | 29.9% |
Sample
| 1st row | {'contact': '', 'other_info': '', 'webpage': '', 'area_code': '', 'phone': '', 'area_code2': '', 'phone2': '', 'email': ''} |
|---|---|
| 2nd row | {'contact': '', 'other_info': '', 'webpage': '', 'area_code': '', 'phone': '', 'area_code2': '', 'phone2': '', 'email': ''} |
| 3rd row | {'contact': '', 'other_info': '', 'webpage': '', 'area_code': '', 'phone': '', 'area_code2': '', 'phone2': '', 'email': ''} |
| 4th row | {'contact': '', 'other_info': '', 'webpage': '', 'area_code': '', 'phone': '', 'area_code2': '', 'phone2': '', 'email': ''} |
| 5th row | {'contact': 'Red Inmobiliaria', 'other_info': '', 'webpage': '', 'area_code': '', 'phone': '', 'area_code2': '', 'phone2': '', 'email': ''} |
| Value | Count | Frequency (%) |
| 78018 | ||
| contact | 10513 | 5.9% |
| other_info | 10511 | 5.9% |
| webpage | 10511 | 5.9% |
| area_code | 10511 | 5.9% |
| phone | 10511 | 5.9% |
| area_code2 | 10511 | 5.9% |
| phone2 | 10511 | 5.9% |
| 10511 | 5.9% | |
| grupo | 972 | 0.5% |
| Other values (2197) | 13948 | 7.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| ' | 336351 | |
| 166677 | ||
| e | 108749 | 7.8% |
| : | 84108 | 6.0% |
| o | 80476 | 5.7% |
| a | 79635 | 5.7% |
| , | 73621 | 5.3% |
| n | 45092 | 3.2% |
| c | 42961 | 3.1% |
| r | 36203 | 2.6% |
| Other values (82) | 346849 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 616868 | |
| Other Punctuation | 495213 | |
| Space Separator | 166677 | 11.9% |
| Uppercase Letter | 46528 | 3.3% |
| Connector Punctuation | 31533 | 2.3% |
| Decimal Number | 22761 | 1.6% |
| Close Punctuation | 10515 | 0.8% |
| Open Punctuation | 10515 | 0.8% |
| Dash Punctuation | 110 | < 0.1% |
| Math Symbol | 2 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 108749 | |
| o | 80476 | |
| a | 79635 | |
| n | 45092 | |
| c | 42961 | 7.0% |
| r | 36203 | 5.9% |
| p | 33733 | 5.5% |
| t | 32531 | 5.3% |
| h | 31711 | 5.1% |
| i | 26727 | 4.3% |
| Other values (23) | 99050 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 6353 | |
| I | 4842 | |
| R | 4741 | |
| O | 3711 | 8.0% |
| E | 3506 | 7.5% |
| S | 2849 | 6.1% |
| N | 2643 | 5.7% |
| L | 2444 | 5.3% |
| G | 2149 | 4.6% |
| M | 1804 | 3.9% |
| Other values (21) | 11486 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 336351 | |
| : | 84108 | 17.0% |
| , | 73621 | 14.9% |
| . | 995 | 0.2% |
| / | 57 | < 0.1% |
| & | 32 | < 0.1% |
| " | 30 | < 0.1% |
| # | 17 | < 0.1% |
| % | 1 | < 0.1% |
| @ | 1 | < 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 21214 | |
| 3 | 290 | 1.3% |
| 4 | 238 | 1.0% |
| 1 | 228 | 1.0% |
| 0 | 175 | 0.8% |
| 8 | 159 | 0.7% |
| 5 | 138 | 0.6% |
| 9 | 124 | 0.5% |
| 6 | 109 | 0.5% |
| 7 | 86 | 0.4% |
Close Punctuation
| Value | Count | Frequency (%) |
| } | 10511 | |
| ) | 4 | < 0.1% |
Open Punctuation
| Value | Count | Frequency (%) |
| { | 10511 | |
| ( | 4 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 166677 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 31533 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 110 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 2 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 737326 | |
| Latin | 663396 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 108749 | |
| o | 80476 | |
| a | 79635 | |
| n | 45092 | 6.8% |
| c | 42961 | 6.5% |
| r | 36203 | 5.5% |
| p | 33733 | 5.1% |
| t | 32531 | 4.9% |
| h | 31711 | 4.8% |
| i | 26727 | 4.0% |
| Other values (54) | 145578 |
Common
| Value | Count | Frequency (%) |
| ' | 336351 | |
| 166677 | ||
| : | 84108 | 11.4% |
| , | 73621 | 10.0% |
| _ | 31533 | 4.3% |
| 2 | 21214 | 2.9% |
| } | 10511 | 1.4% |
| { | 10511 | 1.4% |
| . | 995 | 0.1% |
| 3 | 290 | < 0.1% |
| Other values (18) | 1515 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1400385 | |
| None | 337 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| ' | 336351 | |
| 166677 | ||
| e | 108749 | 7.8% |
| : | 84108 | 6.0% |
| o | 80476 | 5.7% |
| a | 79635 | 5.7% |
| , | 73621 | 5.3% |
| n | 45092 | 3.2% |
| c | 42961 | 3.1% |
| r | 36203 | 2.6% |
| Other values (70) | 346512 |
None
| Value | Count | Frequency (%) |
| Ñ | 75 | |
| ñ | 64 | |
| á | 46 | |
| í | 46 | |
| ó | 39 | |
| é | 24 | 7.1% |
| Ó | 13 | 3.9% |
| Í | 11 | 3.3% |
| Á | 9 | 2.7% |
| É | 5 | 1.5% |
| Other values (2) | 5 | 1.5% |
level_id
Text
MISSING 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 10807 |
| Missing (%) | 8.8% |
| Memory size | 958.7 KiB |
Length
| Max length | 13 |
|---|---|
| Median length | 7 |
| Mean length | 7.064671237 |
| Min length | 5 |
Characters and Unicode
| Total characters | 790459 |
|---|---|
| Distinct characters | 19 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 5_green |
|---|---|
| 2nd row | 5_green |
| 3rd row | 5_green |
| 4th row | 5_green |
| 5th row | 5_green |
| Value | Count | Frequency (%) |
| 5_green | 109536 | |
| 3_yellow | 1105 | 1.0% |
| 4_light_green | 1024 | 0.9% |
| 2_orange | 145 | 0.1% |
| 1_red | 79 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 222449 | |
| _ | 112913 | |
| g | 111729 | |
| r | 110784 | |
| n | 110705 | |
| 5 | 109536 | |
| l | 3234 | 0.4% |
| o | 1250 | 0.2% |
| y | 1105 | 0.1% |
| 3 | 1105 | 0.1% |
| Other values (9) | 5649 | 0.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 565657 | |
| Connector Punctuation | 112913 | 14.3% |
| Decimal Number | 111889 | 14.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 222449 | |
| g | 111729 | |
| r | 110784 | |
| n | 110705 | |
| l | 3234 | 0.6% |
| o | 1250 | 0.2% |
| y | 1105 | 0.2% |
| w | 1105 | 0.2% |
| i | 1024 | 0.2% |
| h | 1024 | 0.2% |
| Other values (3) | 1248 | 0.2% |
Decimal Number
| Value | Count | Frequency (%) |
| 5 | 109536 | |
| 3 | 1105 | 1.0% |
| 4 | 1024 | 0.9% |
| 2 | 145 | 0.1% |
| 1 | 79 | 0.1% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 112913 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 565657 | |
| Common | 224802 | 28.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 222449 | |
| g | 111729 | |
| r | 110784 | |
| n | 110705 | |
| l | 3234 | 0.6% |
| o | 1250 | 0.2% |
| y | 1105 | 0.2% |
| w | 1105 | 0.2% |
| i | 1024 | 0.2% |
| h | 1024 | 0.2% |
| Other values (3) | 1248 | 0.2% |
Common
| Value | Count | Frequency (%) |
| _ | 112913 | |
| 5 | 109536 | |
| 3 | 1105 | 0.5% |
| 4 | 1024 | 0.5% |
| 2 | 145 | 0.1% |
| 1 | 79 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 790459 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 222449 | |
| _ | 112913 | |
| g | 111729 | |
| r | 110784 | |
| n | 110705 | |
| 5 | 109536 | |
| l | 3234 | 0.4% |
| o | 1250 | 0.2% |
| y | 1105 | 0.1% |
| 3 | 1105 | 0.1% |
| Other values (9) | 5649 | 0.7% |
MISSING 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 36130 |
| Missing (%) | 29.4% |
| Memory size | 958.7 KiB |
Length
| Max length | 8 |
|---|---|
| Median length | 6 |
| Mean length | 6.418224245 |
| Min length | 4 |
Characters and Unicode
| Total characters | 555600 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | platinum |
|---|---|
| 2nd row | platinum |
| 3rd row | platinum |
| 4th row | gold |
| 5th row | platinum |
| Value | Count | Frequency (%) |
| platinum | 42427 | |
| gold | 24325 | |
| silver | 19814 |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 86566 | |
| i | 62241 | |
| p | 42427 | |
| a | 42427 | |
| t | 42427 | |
| n | 42427 | |
| u | 42427 | |
| m | 42427 | |
| g | 24325 | 4.4% |
| o | 24325 | 4.4% |
| Other values (5) | 103581 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 555600 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| l | 86566 | |
| i | 62241 | |
| p | 42427 | |
| a | 42427 | |
| t | 42427 | |
| n | 42427 | |
| u | 42427 | |
| m | 42427 | |
| g | 24325 | 4.4% |
| o | 24325 | 4.4% |
| Other values (5) | 103581 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 555600 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| l | 86566 | |
| i | 62241 | |
| p | 42427 | |
| a | 42427 | |
| t | 42427 | |
| n | 42427 | |
| u | 42427 | |
| m | 42427 | |
| g | 24325 | 4.4% |
| o | 24325 | 4.4% |
| Other values (5) | 103581 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 555600 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| l | 86566 | |
| i | 62241 | |
| p | 42427 | |
| a | 42427 | |
| t | 42427 | |
| n | 42427 | |
| u | 42427 | |
| m | 42427 | |
| g | 24325 | 4.4% |
| o | 24325 | 4.4% |
| Other values (5) | 103581 |
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 958.7 KiB |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Characters and Unicode
| Total characters | 981568 |
|---|---|
| Distinct characters | 7 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | historic |
|---|---|
| 2nd row | historic |
| 3rd row | historic |
| 4th row | historic |
| 5th row | historic |
| Value | Count | Frequency (%) |
| historic | 122696 |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 245392 | |
| h | 122696 | |
| s | 122696 | |
| t | 122696 | |
| o | 122696 | |
| r | 122696 | |
| c | 122696 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 981568 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 245392 | |
| h | 122696 | |
| s | 122696 | |
| t | 122696 | |
| o | 122696 | |
| r | 122696 | |
| c | 122696 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 981568 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| i | 245392 | |
| h | 122696 | |
| s | 122696 | |
| t | 122696 | |
| o | 122696 | |
| r | 122696 | |
| c | 122696 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 981568 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| i | 245392 | |
| h | 122696 | |
| s | 122696 | |
| t | 122696 | |
| o | 122696 | |
| r | 122696 | |
| c | 122696 |
transactions_total
Real number (ℝ)
ZEROS 
| Distinct | 3142 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7818.862546 |
| Minimum | 0 |
|---|---|
| Maximum | 100481 |
| Zeros | 9904 |
| Zeros (%) | 8.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 958.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 735 |
| median | 3214 |
| Q3 | 8428 |
| 95-th percentile | 33239 |
| Maximum | 100481 |
| Range | 100481 |
| Interquartile range (IQR) | 7693 |
Descriptive statistics
| Standard deviation | 12751.59588 |
|---|---|
| Coefficient of variation (CV) | 1.630876077 |
| Kurtosis | 13.77994731 |
| Mean | 7818.862546 |
| Median Absolute Deviation (MAD) | 2991 |
| Skewness | 3.27162665 |
| Sum | 959343159 |
| Variance | 162603197.4 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 9904 | 8.1% |
| 3786 | 1094 | 0.9% |
| 6313 | 885 | 0.7% |
| 29955 | 662 | 0.5% |
| 2354 | 634 | 0.5% |
| 51756 | 551 | 0.4% |
| 11386 | 490 | 0.4% |
| 47610 | 473 | 0.4% |
| 7720 | 459 | 0.4% |
| 7764 | 426 | 0.3% |
| Other values (3132) | 107118 |
| Value | Count | Frequency (%) |
| 0 | 9904 | |
| 1 | 346 | 0.3% |
| 2 | 180 | 0.1% |
| 3 | 106 | 0.1% |
| 4 | 114 | 0.1% |
| Value | Count | Frequency (%) |
| 100481 | 300 | |
| 85527 | 380 | |
| 68661 | 307 | |
| 58977 | 159 | 0.1% |
| 56205 | 421 |
user_type
Text
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 958.7 KiB |
Length
| Max length | 18 |
|---|---|
| Median length | 6 |
| Mean length | 6.26196453 |
| Min length | 5 |
Characters and Unicode
| Total characters | 768318 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | brand |
|---|---|
| 2nd row | brand |
| 3rd row | normal |
| 4th row | brand |
| 5th row | normal |
| Value | Count | Frequency (%) |
| normal | 102622 | |
| brand | 15010 | 12.2% |
| real_estate_agency | 3516 | 2.9% |
| franchise | 1228 | 1.0% |
| car_dealer | 319 | 0.3% |
| branch | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 130047 | |
| r | 123015 | |
| n | 122377 | |
| l | 106457 | |
| o | 102622 | |
| m | 102622 | |
| e | 15930 | 2.1% |
| d | 15329 | 2.0% |
| b | 15011 | 2.0% |
| _ | 7351 | 1.0% |
| Other values (8) | 27557 | 3.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 760967 | |
| Connector Punctuation | 7351 | 1.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 130047 | |
| r | 123015 | |
| n | 122377 | |
| l | 106457 | |
| o | 102622 | |
| m | 102622 | |
| e | 15930 | 2.1% |
| d | 15329 | 2.0% |
| b | 15011 | 2.0% |
| t | 7032 | 0.9% |
| Other values (7) | 20525 | 2.7% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 7351 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 760967 | |
| Common | 7351 | 1.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 130047 | |
| r | 123015 | |
| n | 122377 | |
| l | 106457 | |
| o | 102622 | |
| m | 102622 | |
| e | 15930 | 2.1% |
| d | 15329 | 2.0% |
| b | 15011 | 2.0% |
| t | 7032 | 0.9% |
| Other values (7) | 20525 | 2.7% |
Common
| Value | Count | Frequency (%) |
| _ | 7351 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 768318 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 130047 | |
| r | 123015 | |
| n | 122377 | |
| l | 106457 | |
| o | 102622 | |
| m | 102622 | |
| e | 15930 | 2.1% |
| d | 15329 | 2.0% |
| b | 15011 | 2.0% |
| _ | 7351 | 1.0% |
| Other values (8) | 27557 | 3.6% |
category_name
Text
| Distinct | 32 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 958.7 KiB |
Length
| Max length | 30 |
|---|---|
| Median length | 21 |
| Mean length | 18.81188466 |
| Min length | 4 |
Characters and Unicode
| Total characters | 2308143 |
|---|---|
| Distinct characters | 49 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Electrónica, Audio y Video |
|---|---|
| 2nd row | Electrónica, Audio y Video |
| 3rd row | Electrónica, Audio y Video |
| 4th row | Electrónica, Audio y Video |
| 5th row | Electrónica, Audio y Video |
| Value | Count | Frequency (%) |
| y | 79913 | 24.1% |
| accesorios | 11995 | 3.6% |
| para | 4306 | 1.3% |
| antigüedades | 4000 | 1.2% |
| mercería | 4000 | 1.2% |
| series | 4000 | 1.2% |
| películas | 4000 | 1.2% |
| música | 4000 | 1.2% |
| otros | 4000 | 1.2% |
| motos | 4000 | 1.2% |
| Other values (54) | 206902 |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 231237 | 10.0% |
| e | 218934 | 9.5% |
| 208420 | 9.0% | |
| o | 178946 | 7.8% |
| a | 156787 | 6.8% |
| i | 132927 | 5.8% |
| r | 122712 | 5.3% |
| c | 107049 | 4.6% |
| t | 96548 | 4.2% |
| l | 84492 | 3.7% |
| Other values (39) | 770091 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1832830 | |
| Uppercase Letter | 242900 | 10.5% |
| Space Separator | 208420 | 9.0% |
| Other Punctuation | 23993 | 1.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| s | 231237 | |
| e | 218934 | |
| o | 178946 | |
| a | 156787 | 8.6% |
| i | 132927 | 7.3% |
| r | 122712 | 6.7% |
| c | 107049 | 5.8% |
| t | 96548 | 5.3% |
| l | 84492 | 4.6% |
| y | 83911 | 4.6% |
| Other values (20) | 419287 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 35985 | |
| C | 35960 | |
| M | 27958 | |
| R | 15997 | 6.6% |
| P | 15997 | 6.6% |
| B | 12301 | 5.1% |
| E | 12290 | 5.1% |
| J | 11996 | 4.9% |
| V | 11987 | 4.9% |
| O | 11986 | 4.9% |
| Other values (7) | 50443 |
Space Separator
| Value | Count | Frequency (%) |
| 208420 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 23993 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2075730 | |
| Common | 232413 | 10.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| s | 231237 | 11.1% |
| e | 218934 | 10.5% |
| o | 178946 | 8.6% |
| a | 156787 | 7.6% |
| i | 132927 | 6.4% |
| r | 122712 | 5.9% |
| c | 107049 | 5.2% |
| t | 96548 | 4.7% |
| l | 84492 | 4.1% |
| y | 83911 | 4.0% |
| Other values (37) | 662187 |
Common
| Value | Count | Frequency (%) |
| 208420 | ||
| , | 23993 | 10.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2239890 | |
| None | 68253 | 3.0% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| s | 231237 | 10.3% |
| e | 218934 | 9.8% |
| 208420 | 9.3% | |
| o | 178946 | 8.0% |
| a | 156787 | 7.0% |
| i | 132927 | 5.9% |
| r | 122712 | 5.5% |
| c | 107049 | 4.8% |
| t | 96548 | 4.3% |
| l | 84492 | 3.8% |
| Other values (32) | 701838 |
None
| Value | Count | Frequency (%) |
| í | 23996 | |
| é | 15971 | |
| ó | 11983 | |
| á | 4303 | 6.3% |
| ú | 4000 | 5.9% |
| ñ | 4000 | 5.9% |
| ü | 4000 | 5.9% |